how can i see the log..?

Started by lekonalmost 14 years ago2 messages
#1lekon
kukheon1109@gmail.com

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.

#2Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: lekon (#1)
Re: how can i see the log..?

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