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
[EMAIL PROTECTED]
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.
------------------------------------------------------------------------