Re: Feature Request: Ability to move table from one schema to another

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Feature Request: Ability to move table from one schema to another
Date: 2008-02-05 14:41:11
Message-ID: 47A87587.8050004@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Obe, Regina wrote:
> Is there a reason why we don't have the feature in PgAdmin to move a
> table from one schema to another, yet that feature has been available since
> 8.1 with the ALTER TABLE SET SCHEMA ddl command?
>

I sent a patch to allow this in the next release. See
http://www.pgadmin.org/archives/pgadmin-hackers/2007-12/msg00124.php
for more details.

Anyways, I still need to work on this.

> I think it would be a convenient feature, although I guess people would
> need to understand that they would have to manually correct their stored
> functions that reference the old names.
>

Yes, that's right.

Regards.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Obe, Regina 2008-02-05 14:50:40 Re: Feature Request: Ability to move table from one schema to another
Previous Message Obe, Regina 2008-02-05 14:18:09 Feature Request: Ability to move table from one schema to another