[GENERAL] Case sensitive without quotes
Is there any way to have Postgres preserve the case of tables and column names in queries without having to use quotes for columns with mixed case? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Case sensitive without quotes
Jason Long wrote: Is there any way to have Postgres preserve the case of tables and column names in queries without having to use quotes for columns with mixed case? No. PostgreSQL folds to lower-case (the SQL standard specifies upper-case iirc) to provide case-insensitivity. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general