CREATE DATABASE

From: jose <jose(at)sferacarta(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: CREATE DATABASE
Date: 2003-11-10 10:32:16
Message-ID: 3FAF6930.2040508@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message scott.marlowe 2003-11-10 15:29:00 Re: performance problem - 10.000 databases
Previous Message Christian Brosig 2003-11-10 07:33:10 Re: Out of buffer error