PostgreSQL Cheat Sheet

PostgreSQL Cheat Sheet

PostgreSQL Cheat Sheet

To start type:
psql

To list all databases:
\list

To connect to a database:
\c (name of database)

To list tables in connected database:
\dt

To see a table:
select * from (name of a table);

To delete data from a table:
delete from (name of table) where id=(id no);

To delete a database:
drop database (name of database);

To create a database:
create database (name of database);

To quit psql:
\q

update 
insert
delete