Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group