Thread: Variable case database names

Variable case database names

From
Patrick Welche
Date:
   List of databases
  Database  |  Owner
------------+----------
 Newnham    | prlw1

% psql Newnham
psql: connection to database "newnham" failed - FATAL 1:  Database "newnham" does not exist in the system catalog.

template1=> \c 'Newnham'
FATAL 1:  Database "newnham" does not exist in the system catalog.
Previous connection kept


How can I connect to a database with a variable case name?

Cheers,

Patrick