Postgres Pro
Downloads
Home   >   mailing lists

Thread: how can i see the log..?

how can i see the log..?

From
lekon
Date:
i want see the log of INSERT, SELECT, DELETE... within postgresql v9.1.3

i'm so sorry, my english level...

how can i see that.

transaction log?... or other thing...?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-can-i-see-the-log-tp5583083p5583083.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Re: how can i see the log..?

From
"Kevin Grittner"
Date:
lekon  wrote:
> i want see the log of INSERT, SELECT, DELETE... within postgresql
> v9.1.3
The pgsql-hackers list is for discussions about development of the
PostgreSQL datatbase system; discussions about how to use it should
go to another list.  The particular question would be appropriate for
pgsql-general or pgsql-admin.  See this page descriptions of the
various listings to help decide where to post future questions:
http://www.postgresql.org/community/lists/
Regarding the question itself, see the log_statement configuration
setting:
http://www.postgresql.org/docs/9.1/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
-Kevin