Re: Probably a stupid question

From: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Probably a stupid question
Date: 2003-06-27 13:29:43
Message-ID: 3EFC46C7.3050507@ecologic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

greg(at)turnstep(dot)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";

?

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mendola Gaetano 2003-06-27 13:34:22 Re: authentication questions
Previous Message greg 2003-06-27 13:29:19 Re: missing postmaster.conf