Cacher is the code snippet organizer for pro developers

-- backup uncompressed
pg_dump -U user -d database > backup.sql

-- backup and compress
pg_dump dbname | gzip > backup.sql.gz

-- restore from uncompressed
psql -U user database < backup.sql

-- restore from compressed
gunzip -c backup.sql.gz | psql database

-- log to psql
psql -U postgres [-d database]

-- create user
CREATE USER user WITH password 'password';

-- create database
CREATE DATABASE database;

-- create database with owner
CREATE DATABASE database WITH OWNER user;

-- set db owner
ALTER DATABASE database OWNER TO user;

-- drop all tables in database
DROP schema public cascade;
CREATE schema public;