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