I was wondering if field types are case sensitive in SQL, specifically in postgresql. As far as I know SQL key words are generally case insensitive but does this also apply to types? So if I have:

SELECT CAST(item1 AS INT)

is that the same as:

SELECT CAST(item1 AS int)

CodePudding user response：

As far as I know, any named entities in SQL are case insensitive. So are reserved keywords.