Re: I hava a question about case-sensitive

In psql, use

CREATE TABLE "TEST"("NAME" varchar(10));

pgAdmin automatically adds the quotes if required. You are probably better off avoiding upper case though if you can.

Regards, Dave.

-----Original Message-----
From: aiwhite(at)empal(dot)com [mailto:aiwhite(at)empal(dot)com]
Sent: 22 August 2002 08:12
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] I hava a question about case-sensitive


Hi, I'm Korean Student.
I'm sorry that I'm fluent English.
I use Postgresql 7.2.1.
I create table Upper Case(ex. CREATE TABLE TEST(NAME VARCHAR(10));)
But, result is lower case table name and column name.
I use pgadmin2 creating table.
Create Object->Table->Table Name & Column.
In this case, table name and column is upper case.
Why happen that?
How do I prevent that?
I want input case equals ouput case.
Help me.

<http://www.empas.com/> <http://photo.empas.com/> <http://crazy.empas.com/>
* '핫 이슈', '포토뉴스' 등 최신 뉴스 서비스 보강 - 엠파스 뉴스 UP! <http://news.empas.com/>
* 홈페이지 홍보의 가장 좋은 방법 - 엠파스 프리미엄 등록 오픈! <http://add.empas.com/premium/premium_guide1.html>
* 바캉스 앨범에 응모하면 푸짐한 상품이 와르르 - 보는재미 포토앨범 <http://photo.empas.com/>
<http://empal.empas.com/rsd/empalrcpt.html/FCnEGJgYnBmYmJg/mR3v0ZmpwQ/sOAxtODOwsja0txa5urg4N7k6IDg3ubozuTK5uLYXN7kzg/foo.gif>