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

From Dani Oderbolz
Subject Re: Probably a stupid question
Date
Msg-id 3EFC46C7.3050507@ecologic.de
Whole thread Raw
In response to Re: Probably a stupid question  (greg@turnstep.com)
Responses Re: Probably a stupid question  (greg@turnstep.com)
Re: Probably a stupid question  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: Probably a stupid question  (Nabil Sayegh <nas@e-trolley.de>)
List pgsql-novice
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;
>
>DROP TABLE mirrorhosts;
>
>
>
Shouldn't this be


CREATE TABLE mirrorhosts AS SELECT * FROM "MirrorHosts";

DROP TABLE "MirrorHosts";

?





pgsql-novice by date:

Previous
From: greg@turnstep.com
Date:
Subject: Re: missing postmaster.conf
Next
From: greg@turnstep.com
Date:
Subject: Re: Probably a stupid question