move table between schemas

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: move table between schemas
Date: 2008-12-03 01:55:38
Message-ID: 4935E71A.70809@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2008-12-03 02:13:06 Re: move table between schemas
Previous Message Ognjen Blagojevic 2008-12-02 14:42:32 Re: Mailing list problem: TLD .rs not recognized as valid