Re: How to completely move a table to another schema?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Travers <chris(at)travelamericas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to completely move a table to another schema?
Date: 2003-12-10 16:12:16
Message-ID: 6768.1071072736@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Chris Travers <chris(at)travelamericas(dot)com> writes:
> I have a function which moves a table from one schema to another by
> updating the relnamespace field of pg_class:

> Am I missing anything?

pg_constraint entries related to the table.
Also you need to recurse for each index of the table.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jodi Kanter 2003-12-10 20:37:10 picking max from list
Previous Message Tom Lane 2003-12-10 15:51:48 Re: How to specify the beginning of the month in Postgres SQL syntax?