Thread: 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@empal.com [mailto:aiwhite@empal.com]
Sent: 22 August 2002 08:12
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] I hava a question about case-sensitiveHi, 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.
• '핫 이슈', '포토뉴스' 등 최신 뉴스 서비스 보강 - 엠파스 뉴스 UP!
• 홈페이지 홍보의 가장 좋은 방법 - 엠파스 프리미엄 등록 오픈!
• 바캉스 앨범에 응모하면 푸짐한 상품이 와르르 - 보는재미 포토앨범