Postgres Pro
Downloads
Home   >   mailing lists

Re: Logger into table and/or to cli - Mailing list pgsql-general

From Berend Tober
Subject Re: Logger into table and/or to cli
Date
Msg-id 56DEAE5A.3060006@computer.org
Whole thread Raw
In response to Logger into table and/or to cli  ("Thiemo Kellner, NHC Barhufpflege" <thiemo@gelassene-pferde.biz>)
Responses Re: Logger into table and/or to cli
Re: Logger into table and/or to cli
List pgsql-general
Tree view 
Thiemo Kellner, NHC Barhufpflege wrote:
>
> I would like to log from within pgsql into table and/or to command line, something like
> https://sourceforge.net/projects/plnsqllogger/ . Does anybody know of an open source solution
> available?

I like "18.8.4. Using CSV-Format Log Output", although it does not log directly to a data base
table. Rather, it produces comma-separated-value text files that you can easily copy into a data
base table for analysis or other purposes.


See the manual at

http://www.postgresql.org/docs/9.5/static/runtime-config-logging.html

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: index problems (again)
Next
From: Alexander Farber
Date:
Subject: Re: Subtract one array from another, both with non-unique elements