- Архив списков рассылки pgsql-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
============================================