Quotation marks in queries

From: "Martynas Brijunas" <mbrijun(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Quotation marks in queries
Date: 2005-07-14 07:31:33
Message-ID: BAY103-F300942DF1BF51CAA0A65ACAAD10@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Randal L. Schwartz 2005-07-14 07:49:36 Re: To Postgres or not
Previous Message Rob Brenart 2005-07-14 07:14:16 Case insensitive unique constraint