Re: move table between schemas - Mailing list pgsql-novice

Sean Davis wrote:
> On Tue, Dec 2, 2008 at 8:55 PM, Frank Bax <fbax@sympatico.ca> wrote:
>> Is it possible to move a table from one schema to another (in the same database)?
>>
>> The only way I can think of is to:
>>        - backup table
>>        - modify backup file
>>        - restore from modified backup
>>        - delete original table
>>
>> Is there a better/easier way?
>
> ALTER TABLE name
>     SET SCHEMA new_schema
>
> http://www.postgresql.org/docs/current/static/sql-altertable.html
>
>
> Hope that helps.


Yes, very much so; thanks!