Thread: Re: Quotation marks in pgAdmin III
Hi,
Please use the pgadmin-support@postgresql.org mailing list for support.
What sort of object? What did you try to call it?
Regards, Dave.
-----Original Message-----Hi Dave.
From: Alexander N. Treyner [mailto:alex@treyner.israel.net]
Sent: 11 September 2003 10:48
To: dpage@pgadmin.org
Subject: Quotation marks in pgAdmin III
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@treyner.israel.net
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 ).
-- 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@postgresql.org mailing list for support.
What sort of object? What did you try to call it?
Regards, Dave.
-----Original Message-----Hi Dave.
From: Alexander N. Treyner [mailto:alex@treyner.israel.net]
Sent: 11 September 2003 10:48
To: dpage@pgadmin.org
Subject: Quotation marks in pgAdmin III
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@treyner.israel.net