Re: Loging of postgres requests

You can turn up the verbosity of postgres logger to log all SQL
statements. Look in postgresql.conf

In particular, you can set postgres to log statements that take over x
milliseconds to execute. If you set log_min_duration_statement to 0,
then it will log ALL statements, which could also give you what you want
if you want to see all SQL statements.

Terry

Terry Fielder
terry(at)greatgulfhomes(dot)com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085

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.
> ------------------------------------------------------------------------
>
>
>