psql : load query from file and output psql messages to log file

Question

I'm trying to find a one-liner to read query from external file and output psql NOTICEs to a log file. I tried :

psql -h host -d database -U username -f my_sql_file.sql > my_log_file.log

my_sql_file.sql has a multiline anonymous block like :

DO
$$
DECLARE
  stuff 
BEGIN
   RAISE NOTICE '--------- TEST ----------';
END;
$$

The log file outputs the first line of the file : "DO" and nothing else.

Laurenz Albe · Accepted Answer · 2022-02-24 12:50:42Z

2

The notice gets written to standard error, so redirect that too:

psql -h host -d database -U username -f my_sql_file.sql > my_log_file.log 2>&1

answered Feb 24, 2022 at 12:50

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1