Postgres Pro
Downloads
Home   >   mailing lists

Re: How to completely move a table to another schema? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How to completely move a table to another schema?
Date
Msg-id 6768.1071072736@sss.pgh.pa.us
Whole thread Raw
In response to How to completely move a table to another schema?  (Chris Travers <chris@travelamericas.com>)
List pgsql-sql
Tree view 
Chris Travers <chris@travelamericas.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to specify the beginning of the month in Postgres SQL syntax?
Next
From: Jodi Kanter
Date:
Subject: picking max from list