Re: tables with small letters?

On Wednesday 09 February 2005 01:40 am, Mican Bican wrote:

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

pgAdminIII does precisely as you tell it to.  It will enclose an 
identifier in quotation marks if you specify any capital letters in the 
name.  Thus, afterwords, you must specifically quote the name back to it 
identically otherwise it does not see it correctly.

So the moral of the story is, never use capital letters.  Or stop using 
pgAdminIII.  :)  

-- 
_________________________________________________________

  Jon-Pierre Gentil               PGP: 0xA21BC30E
  jabber: [email protected]    web: www.sebistar.net
  "If you think education is expensive, try ignorance."
_________________________________________________________

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iEYEABEDAAYFAkIMFiYACgkQOrVFmaIbww51OACcDOQmZ5DqKL4dSgJXja6QBtfI
zbQAnjUYbrKFNjk4bo3vkTE0/fZeqVu1
=gRKI
-----END PGP SIGNATURE-----