Hi All, We have postgresql running in mac. I found whatever db objects i create from the sql prompt results in lowercase. Can anyone tell me why it is happening.? does postgres stores the db objects in lowercase internally..
If i create something from the shell prompt it remains in the same case i used. Can anyone tell me what is the case limitations we have in postgres for db,table,column names,etc. Thanks Priya __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster