This is only really necessary if the table or column names are mixed cases or include spaces or some such ... normally (?) this is not required. PostgreSQL relentlessly lower cases such names unless they are double quoted.
HTH,
Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Martynas Brijunas
Sent: Thu 7/14/2005 12:31 AM
To: pgsql-general@xxxxxxxxxxxxxx
Cc:
Subject: Quotation marks in queries
Hello,
I am a total newbie to PostgreSql, coming from MS Access background. I have
a question regarding queries in PostgreSql: why do I need to enclose every
field name and table name in quotation marks like
SELECT "Name" From "contacts"
That is a major inconvenience when composing a query string in a VB program.
Thank you.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
!DSPAM:42d6173839122069320068!
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
