Re: Moving a table to a different schema

On 5/29/03 5:23 PM, "Jim C. Nasby" <jim(at)nasby(dot)net> wrote:

> Well, that would *copy* the table... I just want to *move* it. :)
>
> On Thu, May 29, 2003 at 02:31:04PM -0400, Andrew Sullivan wrote:
>> On Thu, May 29, 2003 at 11:14:22AM -0500, Jim C. Nasby wrote:
>>> Is there a command to move an existing table to a different schema?
>>
>> CREATE TABLE targetschem.tablename AS
>> SELECT * FROM sourceschem.tablename

So perhaps finish with

DROP TABLE sourceschem.tablename ?

:>

-- sgl

=======================================================
Steve Lane

Vice President
The Moyer Group
14 North Peoria St Suite 2H
Chicago, IL 60607

Voice: (312) 433-2421 Email: slane(at)moyergroup(dot)com
Fax: (312) 850-3930 Web: http://www.moyergroup.com
=======================================================