Re: [pgadmin-support] Quotation marks in pgAdmin III

[Alexander N. Treyner]

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 [EMAIL PROTECTED] mailing list for support.

 

What sort of object? What did you try to call it?

 

Regards, Dave.

-----Original Message-----
From: Alexander N. Treyner [mailto:[EMAIL PROTECTED]]
Sent: 11 September 2003 10:48
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]