Edit C:\Program Files\PostgreSQL\9.3\data\postgresql.conf and update the following values
#log_statement = 'all'
#log_min_error_statement = error
Restart the service postgresql-x64-9.3
Now you can see all the SQL queries against postgreSQL DB in
C:\Users\<username>\AppData\Roaming\postgresql\pgadmin_histoqueries.xml
#log_statement = 'all'
#log_min_error_statement = error
Restart the service postgresql-x64-9.3
Now you can see all the SQL queries against postgreSQL DB in
C:\Users\<username>\AppData\Roaming\postgresql\pgadmin_histoqueries.xml
No comments:
Post a Comment
Comments will appear once they have been approved by the moderator