Re: Double Quoting Table Names???? - Mailing list pgsql-general

From Edward Muller
Subject Re: Double Quoting Table Names????
Date
Msg-id 1001647513.14258.147.camel@cc234543-a
Whole thread Raw
In response to Re: Double Quoting Table Names????  (wsheldah@lexmark.com)
List pgsql-general
The tables were created using phpPgAdmin30beta.

Here is the SQL used to create one the tables

(phpPgAdmin displays this after the create).

CREATE TABLE "Clients" (
"clientid" SERIAL,
"name" char (40) ,
"startdate" char (6) ,
"enddate" char (6) ,
"isactive" bool ,
"acctnumber" int4 ,
"acctpasswd" char (20) ,
"adminid" SERIAL ,
PRIMARY KEY ("clientid"), UNIQUE ("clientid"));
CREATE INDEX "Clients_clientid_key" ON "Clients"("clientid");
CREATE INDEX "Clients_name_key" ON "Clients"("name");
CREATE INDEX "Clients_startdate_key" ON "Clients"("startdate");
CREATE INDEX "Clients_enddate_key" ON "Clients"("enddate");
CREATE INDEX "Clients_isactive_key" ON "Clients"("isactive");
CREATE INDEX "Clients_acctnumber_key" ON "Clients"("acctnumber");
CREATE INDEX "Clients_acctpasswd_key" ON "Clients"("acctpasswd");

So doing the following query via the phpPgAdmin30 webpage:

SELECT * from Clients;

give me this error:

PostgreSQL said: ERROR: Relation 'clients' does not exist

Doing the same with pgsql give me:

ERROR:  Relation 'client' does not exist

Doing the same query from JDBC give me ... well you get the idea...

Now if I replace SELECT * from Clients; with SELECT * from "Clients"; it
works fine.

Why? Is it because of case?


On Wed, 2001-09-26 at 13:29, wsheldah@lexmark.com wrote:
>
>
> Good point.  I think that SQL Server does this as well.  Reason is to preserve
> any spaces or capital letters in the table names.  Ugh!
>
> Wes
>
>
>
> Mike Mascari <mascarm%mascari.com@interlock.lexmark.com> on 09/26/2001 01:39:00
> PM
>
> To:   Edward Muller <edwardam%home.com@interlock.lexmark.com>
> cc:   pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
>       Sheldahl/Lex/Lexmark)
> Subject:  Re: [GENERAL] Double Quoting Table Names????
>
>
> Edward Muller wrote:
> >
> > I am using a Postgresql 7.1.2 server and it seems that I need to put ""
> > around my table name when doing select queries either using JDBC, PHP or
> > the psql interface.
> >
> > None of the docs that I've looked at indicate that I should need to do
> > this.
> >
> > Can anyone explain this?
>
> How were these tables created? A common cause of this condition is
> that Access users use the Export utility to create the tables via
> the ODBC driver, and Access issues a CREATE TABLE statement with the
> table and column names quoted.
>
> Mike Mascari
> mascarm@mascari.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



pgsql-general by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: Function Help
Next
From: Lincoln Yeoh
Date:
Subject: Re: Encoding passwords