Postgres

TODO options

PG_PASSWORD=secretpassword_envvar psql -h 127.0.0.1 -U postgres db -W

postgresql console

list databases

\l+

connect to database

\c db

list schemas

\dn+

list tables

\dt+

list all tables in all schemas

\dt+ *.*

Set schema

SET search_path TO myschema;

show running queries

SELECT * FROM pg_stat_activity;