Re: weird SQL statement question

From: Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net>
To: Frank Bax <fbax(at)sympatico(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: weird SQL statement question
Date: 2005-04-23 23:57:05
Message-ID: 1114300625.426ae0d1956fc@webmail.telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Quoting Frank Bax <fbax(at)sympatico(dot)ca>:

> At 01:55 PM 4/23/05, Tadej Kanizar wrote:
>
> >Ok, so I installed the latest version of Postresql (8.02) on a
WinXP
> SP2
> >machine..
> >
> >My question is why won't the statement SELECT * FROM table work,
> whereas
> >the statement SELECT * FROM table works!
> If you create a table using quotes and mixed-case, you will need
> quotes
> every time you reference the table. Don't use quotes when you
create
> the
> table and you won't need them when you acces the table with other
> commands.

I don't suppose that the original poster actually named the table
"table"? In which case, being a keyword, it will ALWAYS need quotes.
"Dreams come true, not free." -- S.Sondheim, ITW

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message tuan 2005-04-24 09:18:36 Division in Postgre
Previous Message Frank Bax 2005-04-23 18:30:45 Re: weird SQL statement question