How move a referenced table between schemas?

Поиск
Список
Период
Сортировка
От Andreas
Тема How move a referenced table between schemas?
Дата
Msg-id 4A5A9EEC.5000000@gmx.net
обсуждение исходный текст
Ответы Re: How move a referenced table between schemas?
Список 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 по дате отправления:

Предыдущее
От: Andreas
Дата:
Сообщение: Design question: Should "postgres" own all the db objects?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How move a referenced table between schemas?