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
