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

How to create windows USB installer from windows CD/DVD ?

sudo dd if=/dev/cdrom of=/home/username/image.iso

sudo dd if=/home/username/image.iso of=/dev/sdb

here sdb is your USB drive, change it, it can be /dev/sdc etc.