Difference between revisions of "PostgreSQL"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
Cara 2 | Cara 2 | ||
sudo -u postgres psql | sudo -u postgres psql | ||
| + | |||
| + | |||
| + | ''' Perintah PostgreSQL ''' | ||
| + | |||
| + | Membuat user | ||
| + | sudo -u postgres createuser --interactive | ||
| + | |||
| + | Membuat database | ||
| + | sudo -u postgres createdb namadatabase | ||
Revision as of 13:11, 26 November 2020
Install PostgreSQL di Ubuntu 20.04.01
sudo apt update sudo apt install postgresql postgresql-contrib
Cara akses PostgreSQL
Jika kita mempunyai database dengan nama psql
Cara 1
sudo -i -u postgres psql
Cara 2
sudo -u postgres psql
Perintah PostgreSQL
Membuat user
sudo -u postgres createuser --interactive
Membuat database
sudo -u postgres createdb namadatabase
