RE:

i would guess that order is a reserved word, as its used in queries like
select * from customers order by customerid
so its probably best not to use it as a tablename.
HTH
tamsin

> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of
> juerg(dot)rietmann(at)pup(dot)ch
> Sent: 14 December 2000 15:30
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE]
>
>
> I have a question regarding a strange behaviour.
>
> I use postgreSQL 7.0.3 on SuSE Linux, Coldfusion 4.5.2 SP2 and the pgAdmin
> 7.0.4. For development I use Ultradev 4.0.
>
> I created a database with
>
> createdb customer with a table order.
>
> The query select * from order dosn't work. Doing select * from "order" is
> ok. When i do a query on as system table the quotes are not needed. Since
> Ultradev builds queries without the quotes, I can't use the queries with
> the quotes.
>
> Why do I need the quotes on my new defined table ? Is Encoding the point ?
>
> Thanks in advance ... jr
>
> ============================================
> PFISTER + PARTNER, SYSTEM - ENGINEERING AG
> Juerg Rietmann
> Grundstrasse 22a
> 6343 Rotkreuz
> Switzerland
>
> phone: +4141 790 4040
> fax: +4141 790 2545
> mobile: +4179 211 0315
> ============================================
>
>