PostgreSQL Basic Commands

\l # list databases
\c database_name # connect to database
\dt # list tables
\d table_name # describe table
\du # list users
\q # quit psql

CREATE DATABASE mydb; # create database
DROP DATABASE mydb; # delete database
ALTER DATABASE mydb RENAME TO newdb; # rename database

CREATE SCHEMA myschema; # create schema
DROP SCHEMA myschema CASCADE; # delete schema and contents
SET search_path TO myschema; # set default schema

\conninfo # show connection info
SELECT version(); # PostgreSQL version
SELECT current_database(); # current database

\? # list all psql commands
\h # list SQL commands
\h SELECT # help for SELECT command