Some PostgreSQL snippets

.profile

alias 'pg_sql_restore'='PGPASSWORD=SOMEPASSWORD psql -cO -U username -d dbname -h localhost -f ' # + set path to backup file
alias 'pg_tar_restore'='PGPASSWORD=SOMEPASSWORD pg_restore -cO -U username -d dbname -h localhost ' # + set path to backup file

pg.sql

-- Create statements to delete all tables from current DB
SELECT CONCAT( 'DROP TABLE ', table_name , ' CASCADE;' ) FROM information_schema.tables where table_schema = 'public';

-- Show all tables in current DB
SELECT table_schema,table_name FROM information_schema.tables where table_schema = 'public';