From: | "Alexander N(dot) Treyner" <alex(at)treyner(dot)israel(dot)net> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Quotation marks in pgAdmin III |
Date: | 2003-09-11 10:48:27 |
Message-ID: | 3F6052FB.1050805@treyner.israel.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Any object. New table for example. I created table named Employee and a
few columns for it and got next sql script:
-- Table: public."Employee"
-- DROP TABLE public."Employee";
CREATE TABLE public."Employee"
(
"Employee_Id" int8 NOT NULL DEFAULT
nextval('public."Employee_Employee_Id_seq"'::text),
"First_Name" varchar(50),
"Last_Name" varchar,
CONSTRAINT "pkEmployee" PRIMARY KEY ("Employee_Id")
) WITHOUT OIDS;
As you can see table name is inside quotation marks. - this was not
happen when I created table manually.
Now in my code I need to use next select : "select * from
\"Employee\""" instead of "select * from Employee" that not so
beautiful( I think ).
> Hi,
>
> Please use the pgadmin-support(at)postgresql(dot)org
> <mailto:pgadmin-support(at)postgresql(dot)org> mailing list for support.
>
> What sort of object? What did you try to call it?
>
> Regards, Dave.
>
> -----Original Message-----
> *From:* Alexander N. Treyner [mailto:alex(at)treyner(dot)israel(dot)net]
> *Sent:* 11 September 2003 10:48
> *To:* dpage(at)pgadmin(dot)org
> *Subject:* Quotation marks in pgAdmin III
>
> Hi Dave.
> First of all thank you for a great work.
>
> And now question:
> When I create some object using pgAdmin I get this object named
> with quotation marks. Is it possible to avoid it? How?
>
> Thank you
> Alexander N. Treyner
> alex(at)treyner(dot)israel(dot)net
>
From | Date | Subject | |
---|---|---|---|
Next Message | John Bercik | 2003-09-11 16:38:17 | pgadmin iii ...... pg 7.3.4 |
Previous Message | Dave Page | 2003-09-11 10:23:06 | Re: Quotation marks in pgAdmin III |