Re: Logger into table and/or to cli

From: Berend Tober <btober(at)computer(dot)org>
To: "Thiemo Kellner, NHC Barhufpflege" <thiemo(at)gelassene-pferde(dot)biz>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Logger into table and/or to cli
Date: 2016-03-08 10:50:02
Message-ID: 56DEAE5A.3060006@computer.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2016-03-08 13:28:22 Re: Subtract one array from another, both with non-unique elements
Previous Message Geoff Winkless 2016-03-08 10:16:57 Re: index problems (again)