David Barron <david.barron@zencos.com> writes:
> If, for example, table a has a constraint that references rows in table b, table b has to be restored first, but
pg_dumpdoesn't take that into account.
Yes it does: it doesn't restore foreign key constraints until after
all the data is loaded. What I suspect is that by "constraint" you
mean some handmade hack like a trigger that looks at other tables.
But without details about what you're doing, it's hard to recommend
solutions.
regards, tom lane