How to run a cross database query using the postgres fdw extension.
#postgres #postgresql #docker #sql
I this video, I'll be going over the foreign-data wrapper extension which can be used to access data stored in external PostgreSQL servers.
Source code:
https://github.com/JoeyAlpha5/postgre...
Written tutorial:
/ how-to-run-a-postgres-cross-database-query...
postgres_fdw docs:
https://www.postgresql.org/docs/curre...
Setting up PgAdmin and Postgres using docker-compose:
/ how-to-quickly-set-up-a-postgres-database-...
0:00 - Intro & overview of postgres_fdw extension
2:29 - Installing postgres_fdw extension and creating external server connection
3:42 - Create the user mapping
5:04 - Create foreign table
7:27 - Running the cross database query
▬▬▬▬▬▬ Deals ▬▬▬▬▬▬▬
Use discount code BornToCode_YT for 25%
off on Personal JetBrains licenses.
https://www.jetbrains.com/store/?sect...
#jetbrains #pycharm #webstorm #goland
▬▬▬▬▬▬ Socials ▬▬▬▬▬▬▬
Support on Buy Me Coffee:
https://www.buymeacoffee.com/joeyalpha5
Follow on Twitter:
/ borntocode4
Follow on Instagram:
/ jalome_c
Watch video How to run a cross database query using the postgres fdw extension. online without registration, duration hours minute second in high quality. This video was added by user Born To Code 17 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 386 once and liked it 10 people.