public inbox for [email protected]
help / color / mirror / Atom feedDatabase Name - case sensitivity
3+ messages / 3 participants
[nested] [flat]
* Database Name - case sensitivity
@ 2025-01-21 11:01 Edwin UY <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: Edwin UY @ 2025-01-21 11:01 UTC (permalink / raw)
To: [email protected]
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database Name - case sensitivity
@ 2025-01-21 11:09 Guillaume Lelarge <[email protected]>
parent: Edwin UY <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Guillaume Lelarge @ 2025-01-21 11:09 UTC (permalink / raw)
To: Edwin UY <[email protected]>; +Cc: [email protected]
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* AW: Database Name - case sensitivity
@ 2025-01-21 11:11 William Sescu (Suva) <[email protected]>
parent: Edwin UY <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: William Sescu (Suva) @ 2025-01-21 11:11 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: Edwin UY <[email protected]>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-01-21 11:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-01-21 11:01 Database Name - case sensitivity Edwin UY <[email protected]>
2025-01-21 11:09 ` Guillaume Lelarge <[email protected]>
2025-01-21 11:11 ` AW: Database Name - case sensitivity William Sescu (Suva) <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox