Re: Moving a table to a different schema

Reece Hart <rkh(at)gene(dot)COM> writes:
>> Is there a command to move an existing table to a different schema?

> WARNING: The following works for me, but there might be other
> ramifications that I'm not aware of.

> admin(at)csb-dev=# update pg_class set relnamespace=2200 where
> relname='locus';

You would also need to update the namespace links for the associated
rowtype and for any indexes and constraints on the table. At least if
you wanted things to be clean. I am not sure whether anything critical
depends on these objects being in the same namespace as their parent
table, but certainly the system is not designed to cope with them not
being there.

regards, tom lane