Home > mailing lists

Re: Copy & Re-copy of DB - Mailing list pgsql-general

From	Ken Tanzer
Subject	Re: Copy & Re-copy of DB
Date	January 21, 2021 22:09:13
Msg-id	CAD3a31ULW3QB17zyc_27F+J3DW9mgorOMo3Tgm+Xa1rc=1pPhg@mail.gmail.com Whole thread Raw
In response to	Re: Copy & Re-copy of DB ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
Responses	Re: Copy & Re-copy of DB ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List	pgsql-general

Tree view

On Thu, Jan 21, 2021 at 5:52 AM sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:

create database is to create a new database. If we switch to new database, we need to change the new databasename in the program(s) that access this database.

If you are just concerned about having the same database name, what about renaming (ALTER DATABASE ... RENAME TO) the old and/or new databases so they end up the way you want?

Cheers,
Ken