Re: move table between schemas

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