Skip site navigation (1) Skip section navigation (2)

Re: Quotation marks in pgAdmin III

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Alexander N(dot) Treyner" <alex(at)treyner(dot)israel(dot)net>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Quotation marks in pgAdmin III
Date: 2003-09-11 10:23:06
Message-ID: 03AF4E498C591348A42FC93DEA9661B83AF228@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
If you use mixed case in PostgreSQL then you must quote the identifiers
or it will fold them to lower case. pgAdmin creates tables using the
name you specify - if you use upper case characters then it will quote
them, because PostgreSQL requires that you do so. If you want unquoted
names, you must use lower case. This applies to pgAdmin and psql.
 
 
Regards, Dave.

	-----Original Message-----
	From: Alexander N. Treyner [mailto:alex(at)treyner(dot)israel(dot)net] 
	Sent: 11 September 2003 11:48
	To: Dave Page; pgadmin-support(at)postgresql(dot)org
	Subject: Re: Quotation marks in pgAdmin III
	
	
	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 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
			
			


pgadmin-support by date

Next:From: Alexander N. TreynerDate: 2003-09-11 10:48:27
Subject: Re: Quotation marks in pgAdmin III
Previous:From: Dave PageDate: 2003-09-11 09:33:02
Subject: Re: Quotation marks in pgAdmin III

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group