Removing a schema

From: Naz Gassiep <naz(at)mira(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Removing a schema
Date: 2007-08-07 05:22:03
Message-ID: 46B8017B.3030004@mira.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to remove a schema and move all the tables to another schema.
I've manually run alter table on every table to move them, however all
the foreign keys still reference the old schema, and there are too many
to do by hand.

Is there an easy way to update one of the system catalogs to do this? I
want to change every reference of that schema to point to the new one,
and then drop the schema, but not drop any data.

Thanks,
- Naz.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message son 2007-08-07 06:09:35 how to detect the backup database every day
Previous Message Josh Tolley 2007-08-07 02:37:33 Re: Intelligent Database in postgreSQL