Postgres commands cheat sheet

Connecting to PostgreSQL: Connect to a database: psql -U username -d dbname Connect to a database with host and port: psql -U username -d dbname -h hostname -p port Database Operations: Create a new database: CREATE DATABASE dbname; Delete a da...