Re: Quotes in SQL

On Tue, May 14, 2002 at 11:31:03AM +1000, Martijn van Oosterhout wrote:

> 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.
>

Huh? Doesn't the parser strip off the quotes? Are you saying it stores
the quotes and expects you to provide them when accessing the fields?
(Pardon if this seems like an incredibly dumb question.)

Paul