Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group