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

Database, Table Names are resulting in lowercase

From: Hemapriya <priyam_1121(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database, Table Names are resulting in lowercase
Date: 2004-06-24 14:14:14
Message-ID: 20040624141414.77975.qmail@web21324.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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 

Responses

pgsql-admin by date

Next:From: Andrew BiagioniDate: 2004-06-24 14:50:25
Subject: Re: Database, Table Names are resulting in lowercase
Previous:From: Dragan MaticDate: 2004-06-24 11:56:58
Subject: How can I backup database from database itself

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