Sfrgttk

Some numbers are more equivalent than others

What is this type of notehead called?

On a tidally locked planet, would time be quantized?

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

Did US corporations pay demonstrators in the German demonstrations against article 13?

Divine apple island

Why has "pence" been used in this sentence, not "pences"?

Would it be legal for a US State to ban exports of a natural resource?

Difference between -| and |- in TikZ

How can "mimic phobia" be cured or prevented?

Is possible to search in vim history?

What (else) happened July 1st 1858 in London?

Engineer refusing to file/disclose patents

Is there a conventional notation or name for the slip angle?

Is it improper etiquette to ask your opponent what his/her rating is before the game?

Global amount of publications over time

Will adding a BY-SA image to a blog post make the entire post BY-SA?

Has Darkwing Duck ever met Scrooge McDuck?

How do ground effect vehicles perform turns?

Customize circled numbers

Why in book's example is used 言葉(ことば) instead of 言語(げんご)?

Why is Arduino resetting while driving motors?

When quoting, must I also copy hyphens used to divide words that continue on the next line?

Should I stop contributing to retirement accounts?

Postgres - want a database to have two names

Slow access to table in postgresql despite vacuumWhy does `pg_lsclusters` not list my Postgres cluster?I have an INSTEAD OF trigger, but PostgreSQL still complains while I insert into viewPostgresql - How to Convert all Column Names to LowercaseOdoo Postgres Databases synchronizationExtracting dates from PostgreSQL databasePostgres 10.3 could not bind IPv6 address, database system was not properly shut downTemporarily disable indexes before updating whole tablePostgres, two tables use the same sequence, how to delete one?Is it possible to limit the scope of a SYNONYM in SQL Server?

0

One of my Postgres databases is named entirely in upper-case, and a new bit of software needs to see it in lower-case. I've tried renaming it, but unfortunately that breaks the huge multitude of things that already rely on it being in upper-case (as they've got quotes in the connection string so need it in upper case). Going through and fixing those would be a risky, mammoth undertaking as there is nobody in the company left who originally created the database and all the things that rely on it, and documentation is scarce.

As such, I've come to the conclusion that the best way forwards is to leave the existing database as it is, but to try and have it available by two names - its original name, and a new name. I would imagine just about everyone here already knows of something like this anyway, but I'm relatively new. I've seen terms like alias and synonym in my Googling.

However, I don't believe either of these can be done to an entire database (if I'm wrong then I would be very happy with some information to go on). I've also tried creating an empty database (with the nice new lower-case name) and creating simple views to the original's tables, but of course views don't generally go cross-database.

Anyone got any ideas?

postgresql alias synonyms

share

asked 1 min ago

user25730user25730

1

New contributor

user25730 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

One of my Postgres databases is named entirely in upper-case, and a new bit of software needs to see it in lower-case. I've tried renaming it, but unfortunately that breaks the huge multitude of things that already rely on it being in upper-case (as they've got quotes in the connection string so need it in upper case). Going through and fixing those would be a risky, mammoth undertaking as there is nobody in the company left who originally created the database and all the things that rely on it, and documentation is scarce.

As such, I've come to the conclusion that the best way forwards is to leave the existing database as it is, but to try and have it available by two names - its original name, and a new name. I would imagine just about everyone here already knows of something like this anyway, but I'm relatively new. I've seen terms like alias and synonym in my Googling.

However, I don't believe either of these can be done to an entire database (if I'm wrong then I would be very happy with some information to go on). I've also tried creating an empty database (with the nice new lower-case name) and creating simple views to the original's tables, but of course views don't generally go cross-database.

Anyone got any ideas?

postgresql alias synonyms

share

asked 1 min ago

user25730user25730

1

New contributor

user25730 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

One of my Postgres databases is named entirely in upper-case, and a new bit of software needs to see it in lower-case. I've tried renaming it, but unfortunately that breaks the huge multitude of things that already rely on it being in upper-case (as they've got quotes in the connection string so need it in upper case). Going through and fixing those would be a risky, mammoth undertaking as there is nobody in the company left who originally created the database and all the things that rely on it, and documentation is scarce.

As such, I've come to the conclusion that the best way forwards is to leave the existing database as it is, but to try and have it available by two names - its original name, and a new name. I would imagine just about everyone here already knows of something like this anyway, but I'm relatively new. I've seen terms like alias and synonym in my Googling.

However, I don't believe either of these can be done to an entire database (if I'm wrong then I would be very happy with some information to go on). I've also tried creating an empty database (with the nice new lower-case name) and creating simple views to the original's tables, but of course views don't generally go cross-database.

Anyone got any ideas?

postgresql alias synonyms

share

asked 1 min ago

user25730user25730

1

New contributor

user25730 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

user25730user25730

1

New contributor

user25730 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

user25730user25730

1

New contributor

user25730 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

user25730user25730

1

New contributor

user25730 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

user25730user25730

1