Everyday Work with psql: Meta-Commands, \x, \timing, \copy, \watch, \gexec, .psqlrc, Schemas and search_path
In psql, COPY writes the file to the server disk and needs a special privilege; \copy does the same on the client machine with your privileges. The \d family, \x and \timing, generated SQL with \gset and \gexec, CSV with \copy, \watch, scripts with ON_ERROR_STOP, .psqlrc, schemas and the search_path trap, the public schema privilege change in PostgreSQL 15, and bringing a single table into a dev environment with pg_dump.
15 Nov 2026
·
13 min
·
10
