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 <[EMAIL PROTECTED]> 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 > <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ______________________________________________________________________ Yahoo! GeoCities: a maneira mais fácil de criar seu web site grátis! http://br.geocities.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
