Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Also, if someone restores one table, does the sequence come with it like
> it does now with SERIAL?
Hm, probably not. I do have pg_dump set to force dumping of the
sequence if you try to dump just its table, but it'd be possible to tell
pg_restore (via -l) to load only the table, which could fail. I'm not
too excited about that though; there are plenty of other ways to tell
pg_restore to restore a database subset that won't work.
regards, tom lane