How move a referenced table between schemas? - Mailing list pgsql-general

From Andreas
Subject How move a referenced table between schemas?
Date
Msg-id 4A5A9EEC.5000000@gmx.net
Whole thread Raw
Responses Re: How move a referenced table between schemas?
List pgsql-general
Hi,
how can I move a table from one schema to another even though it is
referenced by foreign keys?

Cloning the table and the manually recreating every reference shouldn't
be the only way, or is it?  :(

How can I dump/export every reference on a table?
Until now I call DROP TABLE and look in the error message for the
referencing tables. There must be a more elegant way, I hope. ;)




pgsql-general by date:

Previous
From: Andreas
Date:
Subject: Design question: Should "postgres" own all the db objects?
Next
From: Tom Lane
Date:
Subject: Re: How move a referenced table between schemas?