Re: see previous queries - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: see previous queries
Date
Msg-id 20031204021642.Y59241@megazone.bigpanda.com
Whole thread Raw
In response to see previous queries  (Ashok Chauhan <ashok@kalculate.com>)
List 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.

pgsql-admin by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: see previous queries
Next
From: Peter Childs
Date:
Subject: Re: see previous queries