CREATE DATABASE - Mailing list pgsql-admin

From jose
Subject CREATE DATABASE
Date
Msg-id 3FAF6930.2040508@sferacarta.com
Whole thread Raw
Responses Re: CREATE DATABASE
Re: CREATE DATABASE
List pgsql-admin
Hi,

PostgreSQL is not consistent in the way it uses upper/lower case to
create databases and access it.
Why psql -c 'CREATE DATABASE name_db'  uses lower(name_db) an less the
name is enclosed by "" but psql name_db ?
Take a look ....

psql template1 -c "create database MYDB"
psql  MYDB

psql: FATAL 1: Database "MYDB" does not exist in the system catalog.

Jo


pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: performance problem - 10.000 databases
Next
From: Markus Bertheau
Date:
Subject: Re: small table occupies many relpages