Postgres Pro
Downloads
Home   >   mailing lists

move table between schemas - Mailing list pgsql-novice

From Frank Bax
Subject move table between schemas
Date
Msg-id 4935E71A.70809@sympatico.ca
Whole thread Raw
Responses Re: move table between schemas  ("Sean Davis" <sdavis2@mail.nih.gov>)
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: Ognjen Blagojevic
Date:
Subject: Re: Mailing list problem: TLD .rs not recognized as valid
Next
From: "Sean Davis"
Date:
Subject: Re: move table between schemas