Re: How move a referenced table between schemas?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: How move a referenced table between schemas?
Date: 2009-07-13 02:45:41
Message-ID: 17192.1247453141@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas <maps(dot)on(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2009-07-13 05:03:24 Re: indexes on float8 vs integer
Previous Message Andreas 2009-07-13 02:41:48 How move a referenced table between schemas?