Re: Redirect RAISE NOTICE and errors to separate log file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


I'm able to achieve it now. Thank you for the hint David.

On Fri, Feb 17, 2023 at 10:29 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
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.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux