Re: [GENERAL] SQL History

2005-05-08 Thread Tom Lane
Michael Ben-Nes <[EMAIL PROTECTED]> writes: > You can set postgresql.conf to log all queries to a file. > Sadly you cant distinguish between the databases. See log_line_prefix in 8.0. regards, tom lane ---(end of broadcast)-

Re: [GENERAL] SQL History

2005-05-08 Thread Michael Ben-Nes
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?! T

Re: [GENERAL] SQL History

2005-05-06 Thread Joshua D. Drake
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?! If you are using psql there is .psql_history. Thanks in advance and your help is appreciated. Hrishi

Re: [GENERAL] SQL History

2005-05-06 Thread Scott Marlowe
On Fri, 2005-05-06 at 12:48, 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. There's a setti

[GENERAL] SQL History

2005-05-06 Thread Hrishikesh Deshmukh
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