Re: I hava a question about case-sensitive - Mailing list pgadmin-support

From Dave Page
Subject Re: I hava a question about case-sensitive
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B86704@salem.vale-housing.co.uk
Whole thread Raw
List pgadmin-support
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-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.


    '핫 이슈', '포토뉴스' 등 최신 뉴스 서비스 보강 - 엠파스 뉴스 UP!
    홈페이지 홍보의 가장 좋은 방법 - 엠파스 프리미엄 등록 오픈!
    바캉스 앨범에 응모하면 푸짐한 상품이 와르르 - 보는재미 포토앨범

pgadmin-support by date:

Previous
From: "홍종근"
Date:
Subject: I hava a question about case-sensitive
Next
From: "Dave Page"
Date:
Subject: Re: Migration plugin not appearing