I've used pgAccess to make all the tables and colums.
Ex.: table diagnosis column diagnosis_ID

Then, when I use psql to execute select statements, diagnosis_ID does
not exist.

But when I change the column name to diagnosis_id it works fine.

The problem is therefore that it is possible to create a column name
with uppercase but psql transforms all statements to lowercase, and
therefore will not work.

(Sorry about my bad English)

Øystein Thorsen
Norwegian student




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to