Re: Probably a stupid question - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Probably a stupid question
Date
Msg-id 1056722134.3251.53.camel@billy
Whole thread Raw
In response to Re: Probably a stupid question  (Dani Oderbolz <oderbolz@ecologic.de>)
List pgsql-novice
Am Fre, 2003-06-27 um 15.29 schrieb Dani Oderbolz:
> greg@turnstep.com wrote:
>
> > ...
> >
> >
> >If you have already created the "MirrorHosts" table and do not want to
> >lose the data inside it, you could do this:
> >
> >CREATE TABLE mirrorhosts AS SELECT * FROM mirrorhosts

ALTER TABLE products RENAME TO items;

At least with 7.3.2

HTH
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: Address Table
Next
From: Dani Oderbolz
Date:
Subject: Which GRANTS are needed on a Sequnce?