Re: pg_dump and serial

Vince Vielhaber <vev@michvhf.com> writes:
> IIRC there was a problem with pg_dump and the serial datatype.

? I've been dumping/restoring serials for a long time without problems.
The only gotcha I can think of is that dumping a single table (-t foo)
doesn't work nicely --- pg_dump doesn't realize that the sequence for
a serial column of foo needs to be included.  But as long as you're
dumping a whole database, no problem.
        regards, tom lane