On Thu, Jan 21, 2021 at 5:52 AM sivapostg...@yahoo.com < sivapostg...@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 -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.