Re: Does pgAdmin have to double-quote table and

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
>
>

--
View this message in context: http://www.nabble.com/Does-pgAdmin-have-to-double-quote-table-and-field-names--tf2574512.html#a7188642
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.