> At 12:14 PM 4/05/2003 +0800, Christopher Kings-Lynne wrote:
> >CREATE TABLE really_long_name (
> > a SERIAL UNIQUE
> >);
>
> At least in production versions, pg_dump does not do this. It will dump it as
> a integer default nextval('really_long_na_seq')
> )
No, 7.3 release dumps tables like this.
Assuming that you've use contrib/adddepend to add the dependencies from
your old tables into the dependencies table. (Which you should do...)
Even if you don't, then any tables you create under 7.3 will certainly be
dumped like that...
Chris