PostgreSQL
Basic Commands
cli
create database
createdb [database-name]
open database
psql [database-name]
seed database
psql < file-name.sql
drop database
dropdb [database-name]
psql
list all databases
/l
connect to specific database
/c [db_name]
list all tables in current database
/dt
get details about a specific table
/d [table_name]
quit psql
/q
Last modified: 10 March 2024