This is exactly what I was doing. I use PostgreSQL Manager Pro. The tool covert all my column name and table name in the double quote. So I have all my column/table/function created in upper case (Oracle habit). Now, I have to quote all of them.
I should stay with psql, I guess. :-) Thanks! At least I know there are people like out there.. :-) ====================================================== >Then I could not access from psql. After banging my head to the wall for >couple days, I then realize I have to use the double quotes. So somehow >pgaccess write the create table statements using doble quotes. >RDB ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings