Raymond O'Donnell wrote:
Since 8.3 creates tables WITHOUT OIDS by default, I'd think just
dumping from 7.4 to 8.3 with 8.3's pg_dump should do the trick. Or am
I missing something?
I could be wrong, but I think 8.3's pg_dump will append WITH (OIDS=TRUE)
if it finds tables with OIDs.
Close. It actually does a "SET default_with_oids = true;" (or false)
prior to the CREATE TABLE statement. In any case, it does preserve the
OID setting of the source database.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
