Re: [SQL] Query history file

On Apr 5, 2005, at 11:29 AM, Mauro Bertoli wrote: From the server side, if you enable 'log_statement' all queries will go into the server logs. Thank you, I enabled log_statement = all log_duration = true You may also want log_min_error_statement = error else any statement that causes an error (suc

Re: [SQL] Query history file

> From the > server side, if you enable 'log_statement' all > queries will go into the > server logs. Thank you, I enabled log_statement = all log_duration = true It's beautiful! :) ___ Nuovo Yahoo! Messenger: E' molto più divertente: Audibles,

Re: [SQL] Query history file

~/.psql_history is everything you typed in psql On Sat, 02 Apr 2005 01:42:05 +0200, Mauro Bertoli <[EMAIL PROTECTED]> wrote: Hi, I've installed a Postgres 8.0. There's a history file with all executed queries? Thanks! ___ Nuovo Yahoo! Messenger: E' molto pià d

Re: [SQL] Query history file

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

[SQL] Query history file

Hi, I've installed a Postgres 8.0. There's a history file with all executed queries? Thanks! ___ Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora! http://it.messenger.yahoo.it