Re: id and ID in CREATE TABLE - Mailing list pgsql-sql

From Josh Jore
Subject Re: id and ID in CREATE TABLE
Date
Msg-id Pine.BSO.4.44.0207190407250.2596-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Re: id and ID in CREATE TABLE  (stefan@extum.com)
List pgsql-sql

Joshua b. Jore ; http://www.greentechnologist.org

On Sat, 20 Jul 2002 stefan@extum.com wrote:

> Why is like this ? Why not letting them upper case if they are not quoted
> ?
>
> stefan

Well.. this is because pgadmin created the attribute as "ID" originally so
for you - it's always been double-quoted to force the case. I never quote
my identifier literals just to avoid all the strange problems (like this)
that happen when you do it. It's just a bad idea.

Josh


pgsql-sql by date:

Previous
From: stefan@extum.com
Date:
Subject: Re: id and ID in CREATE TABLE
Next
From: stefan@extum.com
Date:
Subject: Re: [GENERAL] id and ID in CREATE TABLE