Quotes in SQL

From: Randall Barber <rdb55(at)email(dot)byu(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Quotes in SQL
Date: 2002-05-13 20:49:47
Message-ID: 001001c1fabf$b856ac30$82c5bb80@246upbwork
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi--I'm completely new to PostGres... From what I read in the documentation, sql here is same as there.

SELECT * FROM FOO.BAR WHERE FOO.BAR.BAZ='1234';

However, I just finished building my own PostGres and when I try to use it, I have to do stuff like this:

SELECT * FROM "FOO"."BAR" WHERE "FOO"."BAR"."BAZ" = '1234';

Is this a Postgres thing? Or did I compile it wrong? Or is it an option to create_db?

Thanks for your help
RDB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elaine Lindelef 2002-05-13 20:53:00 Re: Use of OIDS as primary keys
Previous Message Ed Loehr 2002-05-13 19:40:45 Multiple PG Installations with DBD::Pg?