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