Re: CSVLOG fields

From: LazyTrek <lazytrek(at)gmail(dot)com>
To: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: CSVLOG fields
Date: 2010-11-12 06:31:36
Message-ID: AANLkTinseu0mEfJ5GXQ0sPL8pEhQ+pXZGZcOQwWOmVVU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Mladen,

Do you mean something like this?

http://www.postgresql.org/docs/current/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG

It isn't a verbose description but the columns within the table creation
script give enough information to figure out what each item of information
represents.

On Thu, Nov 11, 2010 at 4:58 PM, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>wrote:

> I tested the csvlog option for PostgreSQL and it works beautifully. Where
> can I find the reference information for all fields? I'd like to write a
> little Perl script, something like PgFouine or pgsi, but working on the csv
> version, which is the easiest one to parse.
>
> --
>
> Mladen Gogala Sr. Oracle DBA
> 1500 Broadway
> New York, NY 10036
> (212) 329-5251
> http://www.vmsinfo.com The Leader in Integrated Media Intelligence
> Solutions
>
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jason Tan Boon Teck 2010-11-12 10:00:26 Re: Update a table from another table
Previous Message LazyTrek 2010-11-12 06:26:23 Re: Howto read a UTF-8 CSV with COPY?