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
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
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