Re: SQL History

From: "Joshua D(dot) Drake" <jd(at)commandprompt(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:22:18
Message-ID: 427BB5DA.8070806@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

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 Susemail 2005-05-06 18:27:34 Connecting to Postgres using Rekall
Previous Message Andrew Sullivan 2005-05-06 18:11:25 Re: Slony v. DBMirror