Re: [pgadmin-support] I hava a question about case-sensitive

[Dave Page]

Title: Message

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2002 08:12
To: [EMAIL PROTECTED]
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!     • Ȩ������ ȫ���� ���� ���� ��� - ���Ľ� �����̾� ��� ����!     • ��IJ�� �ٹ��� �����ϸ� Ǫ���� ��ǰ�� �͸��� - ������� ����ٹ�