You can set postgresql.conf to log all queries to a file.
Sadly you cant distinguish between the databases.
Hrishikesh Deshmukh wrote:
Hi All,
Does Postgresql have a "sql history of queries run" capability? Any ideas/pointers will be a great help. Could one capture the order and SQL queries run?!
Thanks in advance and your help is appreciated.
Hrishi
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
-- -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Cel: 972-52-8555757 Fax: 972-4-6990098 http://www.canaan.net.il --------------------------
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
