why-postgresql-does-not-like-uppercase-table-names
are-function-names-in-postgresql-case-insensitive
Are PostgreSQL column names case-sensitive?
how-do-i-list-all-columns-for-a-specified-table
In PostgreSQL, names of identifiers are always folded to lowercase unless you surround the identifier name with double quotes.
you are advised to always quote a particular name or never quote it.
Which basically means all the queries in postgres are by default converted to lowercase letters. But, If you want to create a column with Upper case letters then you must specify it inside the "". And get the data of in uppercase Column(DETAILS), you need to specify the column name in (double-quotes)"". So that postgres treats the data in quotes as Case-sensitive and gives the expected column(DETAILS) values.
没有评论:
发表评论