Re: [SQL] id and ID in CREATE TABLE

2002-07-19 Thread Josh Jore
Joshua b. Jore ; http://www.greentechnologist.org On Sat, 20 Jul 2002 [EMAIL PROTECTED] 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 doubl

Re: [SQL] id and ID in CREATE TABLE

2002-07-18 Thread stefan
I forgot about "" Sorry. So if I would use names quoted then my questions are obsolete. Except one: So actually the only strange part would be PostgreSQL is folding to lower cases a column name ... >From docs: The folding of unquoted names to lower case in PostgreSQL is incompatible with

Re: [SQL] id and ID in CREATE TABLE

2002-07-18 Thread Christopher Kings-Lynne
> Can somebody explain me a bit about: > > 1. As far as I know column names in Tables are not case > sensitive. Correct ? > So I know if I pickup ID is not a clever idea but for this > example it is ok. I think your examples have proved that column names are in fact very much case sensitive. How

[SQL] id and ID in CREATE TABLE

2002-07-18 Thread stefan
Hello all, It might be not a correct place to post this. I am creating a table from psql. Everything is fine except I got some troubles when trying to create the same table but in a different way and with pgaccess. If I have this sql: CREATE TABLE ttt ( ID int2, name text