On Fri, Jun 28, 2002 at 02:50:46PM -0400, Gregory Seidman wrote:
>
> SELECT setval('seq_name', max(serial_column)) FROM appropriate_table;
>
> Unfortunately, I don't think even pg_dump produces this line, though I
> could be wrong.
You are indeed wrong. It is produced by pg_dump (well, actually, it
doesn't use the max() function, but the result is the same).
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@xxxxxxxxxxxxxxx> M6K 3E3
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
