PostgreSQL Cheat Sheet

Help

psql --help

Create a New User

postgres=# create user newusername with password 'supersecretpassword';

bash$ createuser -l -P -E bodhimulti

Create a SuperUser

bash$ createuser -s -P -E newusername

Delete a user

bash-3.2$ dropuser

postgres=# DROP USER username;

Show Databases

\l or psql -l from the command line

Create a Database

create database databasename; or use createdb from commandline

bash$ createdb databasename -O username (owner)

Drop a Database

drop database databasename; dropdb from commandline

Connect with user and database

psql -U username -W databasename

Connects to another database

\c [databasename - [username]]

Show Tables

Describe a table

\d table_name;

Run commands from a file

\i filename

Dump

pg_dump -Ft pinax> pinax.dump.tar

Restore

pg_restore -d pinax pinax.dump.tar

Or import via psql

cat database_name.pgdump | psql -d database_name

Gruntle Enterprise