Re: SQL History

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