public inbox for [email protected]
help / color / mirror / Atom feedFrom: Guillaume Lelarge <[email protected]>
To: Edwin UY <[email protected]>
Cc: [email protected]
Subject: Re: Database Name - case sensitivity
Date: Tue, 21 Jan 2025 12:09:58 +0100
Message-ID: <CAECtzeVEvxcYNGeBnZX158DA9wKTiApUfvWYYxCkBjXPXmcVtA@mail.gmail.com> (raw)
In-Reply-To: <CA+wokJ9TCFH9LQ7YrW8QzbdyF3AJddfX+82W8M5QjFvrxz-JUA@mail.gmail.com>
References: <CA+wokJ9TCFH9LQ7YrW8QzbdyF3AJddfX+82W8M5QjFvrxz-JUA@mail.gmail.com>
Hi,
Le mar. 21 janv. 2025 à 12:02, Edwin UY <[email protected]> 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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Database Name - case sensitivity
In-Reply-To: <CAECtzeVEvxcYNGeBnZX158DA9wKTiApUfvWYYxCkBjXPXmcVtA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox