Advanced psql Features

\o /tmp/result.txt
SELECT * FROM orders;
\o                       -- back to stdout

\i script.sql
\ir relative_script.sql

\! ls -la
\! date

\if :{?prod}
   \echo 'in production'
\elif :debug
   \echo 'debug'
\else
   \echo 'default'
\endif

SELECT count(*) AS n FROM orders \gset
\if :n
   \echo 'orders exist'
\endif

\p          -- print current query buffer
\g          -- re-execute query buffer
\r          -- reset query buffer

\p
\w buffer.sql       -- write buffer to file

\g                  -- execute current buffer
\gx                 -- execute with \x toggle

# ~/.psqlrc
\set QUIET 1
\set HISTSIZE 10000
\pset null '(null)'
\timing on
\set PROMPT1 '%n@%/%R%# '
\unset QUIET

\pset null '(null)'

SELECT count(*) FROM orders WHERE status='new';
\watch 5            -- re-run every 5 seconds

\q
exit
quit       -- all work in PG 11+