| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | "Peter T(dot) Brown" <peter(at)memeticsystems(dot)com> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: case sensitivity |
| Date: | 2001-03-01 02:47:44 |
| Message-ID: | Pine.LNX.4.30.0102282146200.5428-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, 28 Feb 2001, Peter T. Brown wrote:
> I've noticed that when creating databases, column names always end up in
> lower case. Is there anyway to use mixed case column names?
Quote your column names when you create them:
create table mytable (
"Id" integer primary key,
"UserName" varchar(25)
);
You will also have to quote the names in query statements as well, IIRC.
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
If you notice that a person is deceiving you, they must not be
deceiving you very well.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Designer | 2001-03-01 04:35:31 | REMOVAL FROM LIST |
| Previous Message | Peter T. Brown | 2001-03-01 02:10:29 | case sensitivity |