Re: see previous queries

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Ashok Chauhan <ashok(at)kalculate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: see previous queries
Date: 2003-12-04 10:20:05
Message-ID: 20031204021642.Y59241@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Wed, 4 Dec 2003, Ashok Chauhan wrote:

> i am a new user in postgresql.
> problem:- in postgresql there is any command to see history (previous
> day queries) like as history command in linux.

Not precisely. For the backend, you can log the statements that are run
by changing the postgresql.conf and use the log.

In psql, you can get something similar to history with \s I believe, but
that's only for your history not the entire server's history.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Childs 2003-12-04 10:26:13 Re: see previous queries
Previous Message Sai Hertz And Control Systems 2003-12-04 10:03:25 Re: see previous queries