From: | "Mike G(dot)" <mike(at)thegodshalls(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | Andreas Neumann <Andreas(dot)Neumann(at)em(dot)uni-karlsruhe(dot)de>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to "COPY schema1.table TO schema2.table" ? |
Date: | 2005-01-21 17:38:37 |
Message-ID: | 20050121173837.GA8879@thegodshalls.thegodshalls |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Someone once posted to a list a sql script that could be run to move / rename a table from one schema to another.
Don't remember if it was the General or Hacker list. Sorry.
On Fri, Jan 21, 2005 at 10:26:45AM -0700, Michael Fuhr wrote:
> On Fri, Jan 21, 2005 at 05:18:49PM +0100, Andreas Neumann wrote:
>
> > Is there a convenient way to move a table (or a bunch of tables) to a
> > different schema?
>
> It might be possible by fiddling with the system catalogs, although
> I haven't tried it myself.
>
> I'm just brainstorming now, but you could update the table's
> relnamespace column in pg_class. That alone probably wouldn't
> suffice, however -- I'd also look for dependent objects in pg_depend,
> pg_index, etc., and see if they needed to have columns updated as
> well. Maybe somebody else can think of a complete list.
>
> I see that the TODO list has the following item under ALTER:
> "Allow objects to be moved to different schemas."
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Klaus | 2005-01-21 17:43:01 | How to create Geo Types from numeric? |
Previous Message | Michael Fuhr | 2005-01-21 17:26:45 | Re: How to "COPY schema1.table TO schema2.table" ? |