Mimiko schrieb am 02.06.2015 um 13:16:
> 1) mysql widelly uses case-insensitive naming for
> schemas,tables,columns.
So does Postgres. FOO, foo and Foo are all the same name
> But postgres use case-sensitive when doulbe-quoting
Which is what the SQL standard requires (and this was required *long* before MySQL even existed)
> or lowers the names without quoting.
> Is there a configure option to ignore case by default?
Yes: don't use quoted identifiers.
> 2) as program double-quotes the schema,table and column names.
Don't use quoted identifiers. Neither in Postgres nor in MySQL (or any other DBMS)
They give you much more trouble than they are worth it (which you have just learned).
