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