Re: [Pypgsql-users] tables with small letters?

[Jon-Pierre G. <jg...@se...>]

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=20
identifier in quotation marks if you specify any capital letters in the=20
name.  Thus, afterwords, you must specifically quote the name back to it=20
identically otherwise it does not see it correctly.

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

=2D-=20
_________________________________________________________

  Jon-Pierre Gentil               PGP: 0xA21BC30E
  jabber: jg...@se...    web: www.sebistar.net
  "If you think education is expensive, try ignorance."
_________________________________________________________=20