How to join tables across different Neon dbs
What's the best way to join across tables in different Postgres dbs (but that are all Neon)? Is there some approach to this other than the postgres_fdw extension? Does it work differently to access dbs within the same Neon project as it does to access dbs in another Neon project? thanks
1 Reply
rare-sapphire•5mo ago
Each branch within a Neon project runs a separate instance of Postgres, so there's nothing different about query databases on different branches in one Neon project vs querying databases on different branches in different Neon projects. In both cases, you would be querying databases acrosss two instances of Postgres.
Either the postgres_fdw or dblink extension would allow you to do that.
https://neon.tech/docs/extensions/postgres_fdw
https://neon.tech/docs/extensions/dblink