PostgreSQL自动将列名重命名为全小写

Question

I'm converting someone's Microsoft Access database to PHP/PostgreSQL. Referencing all lowercase column names works just fine however the people who created the Access databases "APPARENTLY" "ALWAYS" "SCREAMED" "ALL" "THE" "TIME" "AND" "IT" "MEANS" "HAVING" "TO" "PUT" "QUOTES" "AROUND" "ALL" "COLUMN" "NAMES". I never use capitol letters in column names ever in absolute.

How do I ALTER all the column names so that they have the same names though all lowercase?

There are no same-names/different cases (e.g. there are no column sets like "TableName" and "tableName").

Answer 1

update pg_attribute set attname=lower(attname);

That will make sure there are no upper case letters in any of your tables. You may wish to toss a where clause on there if there are columns that legitimately need an upper case letter.