Re: [GENERAL] Removing a schema

2007-08-07 Thread Tom Lane
Naz Gassiep <[EMAIL PROTECTED]> writes: > 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, What? It works fine for me: regression=# create schema

Re: [GENERAL] Removing a schema

2007-08-07 Thread Nis Jørgensen
Naz Gassiep skrev: > 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 o