Useful PostgreSQL (psql) Console Commands - Quick Reference

Gain access to the PostgreSQL console (Linux)

( using user postgres)

sudo -u postgres psql

List all databases

\l

Connect to a database

\c my_database_name

List all tables in the current (connected to) database

\dt

Shows detailed information about a table

\d my_table_name

See all available commands

\?

Quit postgres CLI

\q

Drop all columns in your db and re-create the DB (with no tables)

drop schema public cascade; create schema public;

Change a user's password

ALTER USER postgres PASSWORD 'newPassword';

References

• official docs on psql commands
• basic psql commands
• drop all columns on your database (but not the database itself)

P.S.: All examples run on psql (PostgreSQL) 9.1.10 on Ubuntu 13.04.