Re: Database Name - case sensitivity

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Database Name - case sensitivity
Date: 2025-01-21 11:09:58
Message-ID: CAECtzeVEvxcYNGeBnZX158DA9wKTiApUfvWYYxCkBjXPXmcVtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Le mar. 21 janv. 2025 à 12:02, Edwin UY <edwin(dot)uy(at)gmail(dot)com> a écrit :

> Hi,
>
> Is there any way to rename a database?
> I have some databases that are in upper case and some that are a mix of
> upper and lower case and I want to rename them all as lowercase.
> For example, I have a TEST and a TestforBlah for example. These are just
> sample names.
>

You need to use double quotes. For example:

ALTER DATABASE "TestforBlah" RENAME TO testforblah;

Regards.

--
Guillaume.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message William Sescu (Suva) 2025-01-21 11:11:13 AW: Database Name - case sensitivity
Previous Message Edwin UY 2025-01-21 11:01:22 Database Name - case sensitivity