Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem with case-sensitivity of database name

problem with case-sensitivity of database name

From
"Leonid V. Kovalev"
Date:
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.
 
 

Re: problem with case-sensitivity of database name

From
Markus Bertheau
Date:
On Thu, 2001-11-29 at 11:31, Leonid V. Kovalev wrote:
> drop database UniSystem,
>
> raise following error:
>
> psql:drop.sql:1: ERROR:  DROP DATABASE: database "unisystem" does not exist

drop database "UniSystem"

PostgreSQL is case sensitive only when such names are quoted.

Markus Bertheau
Attachment