Re: tables with small letters?

Ben Scherrey schrieb:

> Unfortunately table names that aren't pure lower-case are a bit 
> annoying. I converted an app from Access to Postgres and changing the 
> code for all the table names wasn't an option. Try changing your 
> select statement to: 'select * from "Farbton"' and see if that doesn't 
> work. Everywhere you reference a table name you will have to enclose 
> it in "". Its up to you to decide which is the bigger pain in the butt 
> to deal with, quoting table names or changing them to lower case in 
> the db structure.
>
>    good luck,


Thanks Ben .. this was the problem! So I think I is it better to change 
all to lower case in the db structure. But I dont understand why this is 
so?? PgAdminIII generate a sql code, for example create table "Table" 
... so thats mean when i create table manually with create table Table, 
and write a select statement like this: select * from Table without " 
than its works?? Hmm thanks for your help...
(can I turn off the function in pgAdminIII to add the " in the create 
statements?)

--Muhlis



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click