Re: Logging all queries (almost there)

Hi All,

I have set [log_statement=true] in the postgresql.conf
file and now I have all the statements logged. But,
there is a problem:

Once I have more than one database, I had to know in
which database a statement was executed on.

The log file is full of: "select * from stuff", but as
I have more than one database, how can I know where
the [stuff] table is??????

Regards,

Marcelo

 --- MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br>
escreveu: > Hi Franco,
>
> If I set 'log_statement=true', will *all* the
> queries
> sent to the backend be logged???
>
> In which table will it be used to do this log??
>
> Regards,
>
> Marcelo
>
>  --- Franco Bruno Borghesi
> <franco@akyasociados.com.ar> escreveu: > you can set
> the log_statement parameter to true in
> > the configuration
> > file ($PGDATA/postgresql.conf).
> >
> > On Tue, 2004-01-27 at 16:39, MaRCeLO PeReiRA
> wrote:
> >
> > > Hi All,
> > >
> > > Is there any way to log (save) "all" the queries
> > > (select, insert, updade, everything) executed on
> a
> > > database, in a table??
> > >
> > > Regards,
> > >
> > > Marcelo
> > >
> > >
> >
>
______________________________________________________________________
> > >
> > > Yahoo! GeoCities: a maneira mais fácil de criar
> > seu web site grátis!
> > > http://br.geocities.yahoo.com/
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> >
>
> > ATTACHMENT part 2 application/pgp-signature
> name=signature.asc
>
>
>
______________________________________________________________________
>
> Yahoo! GeoCities: a maneira mais fácil de criar seu
> web site grátis!
> http://br.geocities.yahoo.com/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org

______________________________________________________________________

Yahoo! GeoCities: a maneira mais fácil de criar seu web site grátis!
http://br.geocities.yahoo.com/