Re: SQL History

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL History
Date: 2005-05-06 18:00:22
Message-ID: 1115402422.3868.81.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 setting in postgresql.conf that will let you log all queries.
I'm not sure if it gets the order exactly right, or anything like that.

In response to

  • SQL History at 2005-05-06 17:48:04 from Hrishikesh Deshmukh

Browse pgsql-general by date

  From Date Subject
Next Message Mark Borins 2005-05-06 18:01:21 Re: Unicode and unaccent()
Previous Message Brad Nicholson 2005-05-06 17:52:15 Re: Slony v. DBMirror