psql Cheatsheet

psql-cheatsheet.sh

# Start psql
> psql

<current-database>=#

# Exit psql
\q

# Show all tables
\dt

# Show all roles
\du

# Show all databases
\l

# Create new database using createdb (not within psql shell)
> createdb <database>

# Switch to a different database
\c <database>

# Execute SQL statements
<current-database>=# SELECT * FROM product;

# Login with role and connect to specific database
> psql -U <role> -d <database>