Re: ALTER TABLE schema SCHEMA TO new_schema?

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: ALTER TABLE schema SCHEMA TO new_schema?
Дата
Msg-id 1038861282.46704.83.camel@jester
обсуждение исходный текст
Ответ на Re: ALTER TABLE schema SCHEMA TO new_schema?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
> Why just restrict them to moving tables?  What if someone wants to move a
> function or an aggregate to another schema?
>
> What if they want to copy it?

Copying might be tricky, but I'd be happy to help with moving everything
else around.  Though I don't think sequences can move (until we can
properly track their dependencies) but everything else should be able
to.

Copy is another story all together.  But I'd like a

CREATE SCHEMA ... AS COPY <schemaname>;

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: ALTER .. ADD PRIMARY KEY
Следующее
От: "Magnus Naeslund(f)"
Дата:
Сообщение: Re: 7.4 Wishlist