Postgres Commands


published 1970-01-01 00:00

updated 1970-01-01 00:00

%date 20200109-1320

Quick Tips

\l List all Databases \c <database> Connect to a database \dt List all tables (once connected to a db) DELETE FROM <table> WHERE <condition> delete rows from a table Strings must be wrapped in '' create a table: CREATE TABLE <table_name>( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );