postgres commands cheatsheet

$ sudo -i -u postgres
$ psql


Create new database
CREATE DATABASE schooldb;

Create new user
CREATE USER schooluser;

Change Password
ALTER USER schooluser with PASSWORD 'pass123';

Change database owner
ALTER database schooldb owner to schooluser;

Rename database name

ALTER DATABASE name RENAME TO newname

Grant All Permissions to database

grant all privileges on database dbname to dbuser;

GRANT ALL ON DATABASE somedb TO someuser;

Show databases
\l

Show tables
\dt

Connect to db
\c schooldb