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: [EMAIL PROTECTED] on behalf of Martynas Brijunas
Sent: Thu 7/14/2005 12:31 AM
To: pgsql-general@postgresql.org
Cc:
Subject: [GENERAL] 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 [EMAIL PROTECTED] 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
