Re: Explicitly adding a table to a schema.

Поиск
Список
Период
Сортировка
От Demitri Muna
Тема Re: Explicitly adding a table to a schema.
Дата
Msg-id 49D30CCA-F699-41D1-87C5-B31FDD38F61D@mac.com
обсуждение исходный текст
Ответ на Re: Explicitly adding a table to a schema.  (Adam Cornett <adam.cornett@gmail.com>)
Ответы Re: Explicitly adding a table to a schema.  (Adam Cornett <adam.cornett@gmail.com>)
Re: Explicitly adding a table to a schema.  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Explicitly adding a table to a schema.  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
Hi,

On Nov 4, 2011, at 2:09 PM, Adam Cornett wrote:

> You can use ALTER TABLE (http://www.postgresql.org/docs/current/static/sql-altertable.html) to set the schema of
existingtables: 
> ALTER TABLE foo SET SCHEMA bar

Thanks. I did try that, but that command moves the table to a different schema, which is not what I'm trying to do. It
struckme to try to move it to another schema (where the definition then explicitly included the schema prefix) and then
moveit back, but it still doesn't have the schema prefix. 

Cheers,
Demitri

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

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: 9.1 replication on different arch
Следующее
От: Adam Cornett
Дата:
Сообщение: Re: Explicitly adding a table to a schema.