On Fri, Feb 17, 2023 at 9:52 AM Nikhil Ingale <niks.bgm@xxxxxxxxx> wrote:
I need the non query output in the user defined log file.How can I achieve that?
Learn shell scripting.
At its simplest, have the user replace "/dev/null" in my example with whatever path they want.
psql doesn't expose specifying a non-query output channel so you are forced to deal with this in a higher/wrapper layer where you can manipulate stderr.
David J.