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.
signature.asc
Description: Digital signature
