PSQL: "\set ECHO all" doesn't work with "\o" - Mailing list pgsql-sql

From Alberto Benini
Subject PSQL: "\set ECHO all" doesn't work with "\o"
Date
Msg-id e0b4495abaa4c9bfeff2e75f6ae60e88@mail.gmail.com
Whole thread Raw
Responses Re: PSQL: "\set ECHO all" doesn't work with "\o"  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql

Hi all,

I haven’t understand how to redirect SQL errors on output file.

 

Our goal is to have a psql script with:

 

\set ON_ERROR_STOP true

\set ECHO all

\o log/update.log;

\i update.sql;

 

 

..but in the log file we don’t see any sql error

 

KR,

Alberto

 

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: Re: automatic scan a table, report on data formats in columns
Next
From: "David G. Johnston"
Date:
Subject: Re: PSQL: "\set ECHO all" doesn't work with "\o"