Postgres Run : psql -d test -U postgres -W Most frequently used commands : Desciption Command Show all databases \l Select a database to work-on \c dbname Login as superuser sudo -u postgres psql Show structure of table \d+ tablename Quit Postgres cli mode \quit Terminate all open sessions SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() Export database pg_dump db_name > file_name.sql Export database pg_restore -U postgres -d db_name -v file_name.sql Import database psql -d db_name -U postgres -f file_name.sql Write Data from database to CSV File Copy (select * from table where column = id) To 'file_name.csv' With CSV DELIMITER ','; Sources: postgres 9.5 documentation postgresql-login-commands 15-practical-postgresql-database-adminstration-commands
