Re: backup tableoids (pg_class.oid) ?

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> fkater(at)googlemail(dot)com wrote:
>> my db structure relays on the OIDs of tables (stored as OIDs of
>> pg_class).

> Probably it would be a better idea to store that as type regclass
> instead of OIDs. I think that will take care of the dump part of the
> problem, at least.

+1

> It's likely that there will be an additional hurdle
> when trying to restore, because the referenced table would not have been
> created in the first place.

I think you'd probably be able to get away with it, because pg_dump
always creates all tables before loading any data. If you were storing
index OIDs, maybe it wouldn't work.

regards, tom lane