Re: Loging of postgres requests

On Saturday 15 March 2008 2:29 pm, Dave Potts wrote:
> I am using a 3rd front end to generate  postgres requests , its reportng
> an error with the database.
>
> Is there anyway of loging which sql requests the application is  actual
> sending to postgres.  I need to known if the error is being created by
> the application generating invalid SQL or if there is a problem with the
> desgin of the database tables.
>
> Dave.
See:
http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html
In particular you will want to set log_statement to 'all'  to see the SQL.
--
Adrian Klaver
aklaver@comcast.net