[GENERAL] review SQL command history?

2006-06-02 Thread 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...

TIA,
t.n.a.

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [GENERAL] review SQL command history?

2006-06-02 Thread Peter Eisentraut
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/

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org