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