I have a QGIS project which uses PGSQL in the back end. I am now setting up multiple instances of the database (dev, working and published) with a mechanism to migrate data between the in a systematic manner.
Is there a straight forward way of changing the database name in a QGIS project so I can quickly test things after performing migrations? i.e just change the database leaving schema, tables. etc the same.