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])