From: Mischa Sandberg <mischa.sandberg@telus.net>
To: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: weird SQL statement question
Date: Sat, 23 Apr 2005 16:57:05 -0700
Message-ID: <1114300625.426ae0d1956fc@webmail.telus.net> (raw)
In-Reply-To: <5.2.1.1.0.20050423142822.04965cf0@pop6.sympatico.ca>
References: <5.2.1.1.0.20050423142822.04965cf0@pop6.sympatico.ca>
Quoting Frank Bax <fbax@sympatico.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mischa.sandberg@telus.net, fbax@sympatico.ca
Subject: Re: weird SQL statement question
In-Reply-To: <1114300625.426ae0d1956fc@webmail.telus.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox