Postgres Pro
Downloads
Home   >   mailing lists

Re: How move a referenced table between schemas? - Mailing list pgsql-general

From Tom Lane
Subject Re: How move a referenced table between schemas?
Date
Msg-id 17192.1247453141@sss.pgh.pa.us
Whole thread Raw
In response to How move a referenced table between schemas?  (Andreas <maps.on@gmx.net>)
List pgsql-general
Tree view 
Andreas <maps.on@gmx.net> writes:
> how can I move a table from one schema to another even though it is
> referenced by foreign keys?

ALTER TABLE SET SCHEMA.  The foreign keys don't care (at least not
in any remotely modern PG release).

            regards, tom lane

pgsql-general by date:

Previous
From: Andreas
Date:
Subject: How move a referenced table between schemas?
Next
From: Dennis Gearon
Date:
Subject: Re: indexes on float8 vs integer