public inbox for [email protected]
help / color / mirror / Atom feedFrom: William Sescu (Suva) <[email protected]>
To: [email protected] <[email protected]>
Cc: Edwin UY <[email protected]>
Subject: AW: Database Name - case sensitivity
Date: Tue, 21 Jan 2025 11:11:13 +0000
Message-ID: <GV0P278MB02441BA6A34EB7F487F898E8E8E62@GV0P278MB0244.CHEP278.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CA+wokJ9TCFH9LQ7YrW8QzbdyF3AJddfX+82W8M5QjFvrxz-JUA@mail.gmail.com>
References: <CA+wokJ9TCFH9LQ7YrW8QzbdyF3AJddfX+82W8M5QjFvrxz-JUA@mail.gmail.com>
Alter database rename should do the job ..
(postgres@[local]:58888)[postgres]> create database "TestForBlah";
CREATE DATABASE
(postgres@[local]:58888)[postgres]> \l "TestForBlah"
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+-------------------
TestForBlah | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(1 row)
(postgres@[local]:58888)[postgres]> ALTER DATABASE "TestForBlah" RENAME TO test;
ALTER DATABASE
(postgres@[local]:58888)[postgres]> \l test
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------+----------+----------+-------------+-------------+-------------------
test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(1 row)
Von: Edwin UY <[email protected]>
Gesendet: Dienstag, 21. Januar 2025 12:01
An: [email protected]
Betreff: Database Name - case sensitivity
ACHTUNG: Diese Nachricht kommt von extern. Seien Sie kritisch beim Öffnen von Links und Anhängen.
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.
________________________________
Disclaimer:
Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Attachments:
[application/pkcs7-signature] smime.p7s (5.8K, 3-smime.p7s)
download
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: AW: Database Name - case sensitivity
In-Reply-To: <GV0P278MB02441BA6A34EB7F487F898E8E8E62@GV0P278MB0244.CHEP278.PROD.OUTLOOK.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