Re: Probably a stupid question - Mailing 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";

?