When i try to write SQL commands, schema name are systematically lowercased, but meaning the feedback inconsistant.
Having a schema already created, named "TEST" (capitalized)
I try « CREATE TABLE TEST.test_schema ( id integer ); »
I got :
CREATE TABLE TEST.test_schema ( id integer )
Error in query: ERROR: schema "test" does not exist
but writing « create schema TEST; »
leads to :
create schema TEST
Query executed OK, 0 rows affected. (0.015 s) Edit
in fact, the credated schema is named "test" in lowercase.