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
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
> 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
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