Skip site navigation (1) Skip section navigation (2)

From: juerg(dot)rietmann(at)pup(dot)ch
To: pgsql-novice(at)postgresql(dot)org
Subject:
Date: 2000-12-14 15:29:45
Message-ID: OF1E05C49B.3A8269FA-ONC12569B5.00549ED7@pup.ch (view raw or flat)
Thread:
Lists: 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
============================================


Responses

  • RE: at 2000-12-14 19:41:21 from Tamsin
  • Re: at 2000-12-14 19:42:12 from Tom Lane

pgsql-novice by date

Next:From: ghaverlaDate: 2000-12-14 15:53:00
Subject: Re: Creating Log file - run in background.
Previous:From: John BurskiDate: 2000-12-14 15:24:53
Subject: Re: Creating Log file - run in background.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group