problem with case-sensitivity of database name

From: "Leonid V(dot) Kovalev" <l(dot)kovalev(at)s7(dot)ru>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: problem with case-sensitivity of database name
Date: 2001-11-29 10:31:08
Message-ID: 001a01c178c0$f5383500$af2f97c3@hdq.s7
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello.

there is a problem with drop database named 'UniSystem'.

executing command

psql -f drop.sql template1
where drop.sql file consists only one line:
drop database UniSystem,

raise following error:

psql:drop.sql:1: ERROR: DROP DATABASE: database "unisystem" does not exist

Instead of this, database named 'unisystem' can be created and droped correctly.

Please help, how to rename/drop database with up-case symbols in name?

great thanx,

Leonid Kovalev.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew Nation 2001-11-29 11:21:57 Where do I start
Previous Message James Reid 2001-11-29 10:20:41 spatial index