Wim Bertels wrote: > but interactively this doesn't seem to work Interactively something like this might do the job: $ PSQL_HISTORY=/tmp/queries.txt psql -L /tmp/logfile.txt After running some queries, and a clean exit from psql: $ cat /tmp/queries.txt select 1; select 2; $ cat /tmp/logfile.txt ********* QUERY ********** select 1; ************************** ?column? ---------- 1 (1 row) ********* QUERY ********** select 2; ************************** ?column? ---------- 2 (1 row) Best regards, -- Daniel Vérité PostgreSQL-powered mailer: https://www.manitou-mail.org Twitter: @DanielVerite
