review SQL command history?

Started by Tomi NAalmost 20 years ago2 messagesgeneral
Jump to latest
#1Tomi NA
hefest@gmail.com

Is there a way to see SQL command history (specifically, a number of
INSERTS in a batch command) that happened a couple of weeks ago? I
need to see if a database was initialized with the correct data...

TIA,
t.n.a.

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Tomi NA (#1)
Re: review SQL command history?

Am Freitag, 2. Juni 2006 10:30 schrieb Tomi NA:

Is there a way to see SQL command history (specifically, a number of
INSERTS in a batch command) that happened a couple of weeks ago? I
need to see if a database was initialized with the correct data...

If you turned on statement logging, it's in your server log. If not, then no.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/