Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

Next:From: Andrew NationDate: 2001-11-29 11:21:57
Subject: Where do I start
Previous:From: James ReidDate: 2001-11-29 10:20:41
Subject: spatial index

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group