Re: Quotes in SQL

On Mon, May 13, 2002 at 02:49:47PM -0600, Randall Barber wrote:
> 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?

That's normal. If you use quotes when you create the table, you (usually)
need quotes when accessing the fields. If you don't use quotes when creating
the table, you don't need them when accessing.

HTH,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America