Re: Query history file - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Query history file
Date
Msg-id 200504030256.j332uYd11489@candle.pha.pa.us
Whole thread Raw
In response to Query history file  (Mauro Bertoli <bertolima@yahoo.it>)
List pgsql-sql
Mauro Bertoli wrote:
> Hi, 
>  I've installed a Postgres 8.0. 
> There's a history file with all executed queries?

If you are using psql, \s will show you your old queries.  From the
server side, if you enable 'log_statement' all queries will go into the
server logs.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-sql by date:

Previous
From: _moray
Date:
Subject: a very big table
Next
From: Tom Lane
Date:
Subject: Re: Date/Time Conversion