SQL Cheat Sheet

Postgress

HOST="host-url.com"
PORT=5432
USER="username"
DATABASE="employees"

PGPASSWORD='<enter password> psql -h $HOST -p $PORT -U $USER -d $DATABASE

\l

\c <database_name>

SELECT current_database();

CREATE DATABASE <database_name> WITH OWNER <username>;

DROP DATABASE IF EXISTS <database_name>;

ALTER DATABASE <old_name> RENAME TO <new_name>;

SHOW SERVER_VERSION;

\conninfo

SHOW ALL;

SELECT rolname FROM pg_roles;

SELECT current_user;

\du

\dt

\d <table>

\d+ <table>

\dt

HOST="host-url.com"
PORT=5432
USER="username"
DATABASE="employees"

pg_dump --schema-only -U $USER -d $DATABASE -h $HOST -p $PORT  > pgdump_file.sql