psql CLI

psql -d mydb -U myuser

Root login

psql -U postgres

Show all tables

\dt

Show all schemas

\dn

Check version

select version();

Create schema

CREATE SCHEMA myschema;

Change schema

SET search_path TO myschema;

Quit CLI

\q

Export query to CSV

psql --dbname=mydb --username=dbuser --host=127.0.0.1 \
     -c "COPY (SELECT * FROM widget) TO stdout \
     DELIMITER ',' CSV HEADER" > export.csv