Postgres Pro
Downloads
Home   >   mailing lists

problem with case-sensitivity of database name - Mailing list pgsql-novice

From Leonid V. Kovalev
Subject problem with case-sensitivity of database name
Date
Msg-id 001a01c178c0$f5383500$af2f97c3@hdq.s7
Whole thread Raw
Responses Re: problem with case-sensitivity of database name
List pgsql-novice
Tree view
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.
 
 

pgsql-novice by date:

Previous
From: Bryan Buchanan
Date:
Subject: Re: Where do I start
Next
From: Markus Bertheau
Date:
Subject: Re: problem with case-sensitivity of database name