I am having a discussion re pgsql double quoting or not in the General mailing list, it's buried in the thread titled "Simple stored procedure examples?" As far as I understand things, pgsql ignores case, unless I explicitly use surround table and field names etc with double quotes. If I use the double quotes then pgsql requires me to use referenece those objects using double quotes and the exact case that I did originally. I'm not even sure that I'm correct about all of that, but if I am, it seems that pgAdmin is adding an uneccessary layer by automaticallly double quoting table and field names that are not all lowercase.
This is important to me because I want to use namestyles like Item and ItemName, and I don't want to have to double quote every table and field reference. It seems that pgsql itself is fine with my preferred style but that pgAdmin is effectively preventing it? I like pgAdmin otherwise so I'd prefer not to have to hunt down a different editor.
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
