Thread: move table between schemas

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?

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.

Sean

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!