The Postgress database appears with an uppercase field name but does not exist.

Select BSK001 from Dbdata

Error: Column "bsk001" of relation "dbdata" does not exist.

The reason is that the fields in the database are named BSK001, and the uppercase letters are automatically converted to lowercase in SQL statements;

That is, the select BSK001 from Dbdata is the same as the select bsk001 from Dbdata;

Does the postgress database fail to operate green if it encounters an uppercase field name?

Select "BSK001" from dbdata resolves the field name in double quotation marks.

The Magical postgress database, which also supports data in formats such as Json,xml

The Postgress database appears with an uppercase field name but does not exist.