Frequently used Postgresql commands

Postgresql Cheat Sheet

sudo su - postgres

create database #{DATABASE_NAME};


psql -U postgres

//list all dbs
postgres-# \l

//connect to the db
postgres-# \c [database_name]：

//list all the tables in the current db
postgres-# \d：

//delete a row
DELETE FROM #{table_name} WHERE #{condition}

// common error when deleting a row
Error: update or delete on table #{table_name} violdates foreign key constraint #{a_key_name} on table #{table_name_2}
Detail: key is still referenced from the table #{table_name_2}