I see, so to make it explicit, if I'd named my table item not Item, and the column itemname not ItemName, pgAdmin (and pgsql) wouldn't need to double quote. Not my preference but I'll live.
Thanks
Dave Page-3 wrote:
novnov wrote:
> As far as I can tell pgsql itself does not require table and field names to
> be wrapped in double quotes, but pgAdmin does that by default (at least on
> windows).
PostgreSQL does require you to use double quotes in some circumstances
(for example, if you use upper case letters). pgAdmin automatically
quotes identifiers if you use a name that requires them.
> What's the rationale? I've not found a way to turn this off in
> pgAdmin, is there a way, is it safe to do this?
No, you cannot turn it off, and yes, it is safe as long as you remember
to quote things appropriately outside of pgAdmin. See
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
for more info.
> It's a very nice package, btw, thanks to all of the contributors.
You're welcome.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
