Thread: review SQL command history?

review SQL command history?

From
"Tomi NA"
Date:
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.

Re: review SQL command history?

From
Peter Eisentraut
Date:
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/