The following bug has been logged online:

Bug reference: 2742
Logged by:
Email address: chad.wilson (AT) ngc (DOT) com
PostgreSQL version: 8.0rc5
Operating system: Linux Red Hat 8
Description: psql -c is not case sensitive
Details:

psql -c is not case sensitive...

If a schema is created with the command
psql -d dbname -c "CREATE SCHEMA "SCHEMA_name"
and is executed at the command line, then a schema is created for dbname
with the name schema_name.

If a schema is created with the commands
psql dbname
CREATE SCHEMA "SCHEMA_name";
and is executed from the psql command, then a schema is created for dbname
with the name SCHEMA_name.

Does this appear to be a bug?

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"" <chad.wilson (AT) ngc (DOT) com> writes:
I think you need to reflect on the properties of the shell's quoting
conventions --- that will come through to psql and hence the backend
with no quotes.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster