On Friday 14 November 2003 16:15, Thomas LeBlanc wrote:
> Are there settings in PostgreSQL to log SQL Statements from client apps?
>
> Is yes, where are they logged to?
>
> We set log_statement=On, but where does the log get sritten to?
Depends on how you start PG - you'll need to check your startup scripts.
If you want to, you can set it up to use syslog (set syslog=2, see the
relevant section of the manuals)
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
