Postgres cheat sheet

cheatsheet.psql

# Start psql
psql "sslmode=require host=postgres-azure.postgres.database.azure.com user=admin@postgres-azure dbname=postgres"

# Connect to database
\c mydatabase

# Show databases
\l

# Show tables
\dt+

# Show users
\du+

# Disconnect sessions
SELECT pg_terminate_backend(pid);

# Show max connections
SHOW max_connections;