On Sun, Nov 05, 2006 at 08:51:52AM -0800, novnov wrote:
> I would really prefer it if simple names like Item and ItemName not be
> double quoted. You're saying that postgres itself would only require double
> quotes if the table was originally decribed that way (and it is, being
> created by pgAdmin). Seems like an odd mismatch between pgsql and pgAdmin,
> why would pgAdmin take the seemingly uneccessary step of double quoting
> names like Item?
Evidently, pgAdmin sees you using uppercase letters and decides to
quote them. It could also not quote them, then it would be case
insensetive.
If you create the table with lowercase, does pgadmin allow you to refer
to them with mixed case? I don't use pgAdmin, so I can't really say
much about this.
> Any suggestions for a db admin tool that does not introduce this error?
I don't use pgAdmin, the only tool I use is psql, and it doesn't
automatically quote anything, ever.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.