Remote views – or – postgresql to postgresql cross database copy / SQL access
Note: this was done using the “postgres” superuser, granting this kind of access to a non-superuser requires additional steps / permissions Note: setting up cross database access requires setup on the “target” side, and does require that you specify a “user_mapping” that has/knows the credentials back on the source side — ***** create foreign data …
Remote views – or – postgresql to postgresql cross database copy / SQL access Read More »