pg-promise API recommends an initial connection object like:

```
var pgp = require('pg-promise')();
const mysqlcon = `postgres://${process.env.DB_USER}:${process.env.DB_PASSWORD}@${process.env.DB_HOST}:5432/my_database}` //note that 'my_database' is hardcoded here
var db = pgp(mysqlcon);
module.exports = db;

```

then I use this object to query *table\_customers* in *my\_database* database:

```
var db = require('./models/postgres')
db.many('SELECT * from table_customers')
  .then(function (data) {
    console.log('DATA:', data)
  })
  .catch(function (error) {
    console.log('ERROR:', error)
})

```

This works perfectly fine, but if I were to select another table from another database, how could I dynamically modify the connection object to change **my\_database** to **another\_database**?