#80 Support for case sensitive schema names in PostgreSQL

open
John Currier
5
2011-10-03
2011-10-03
Anonymous
No

I would be great if schema names in SQL queries were properly quoted. Currently in Postgres, schema with upper case names aren't properly analyzed. I understood from other similar topics t hat it might break other things, but making the option would be a really great addition!!
Thanks

Discussion

  • John Currier
    John Currier
    2011-10-03

    From what I understand there is no such thing as "properly quoted" in that each vendor can have its own set of rules, many of which conflict between different vendors. I thought we had come up with a mechanism to determine an appropriate quoting, but evidently that doesn't always work. How is the "aren't property analyzed" behavior exhibited?

    Note that SchemaSpy internally ignores case on identifier names due to the significant inconsistency between the results of metadata services and hand-formed SQL.

    John