Foreign Data Wrappers: Accessing External Data from a PostgreSQL database

Published: 20 March 2020
on channel: Southern California Linux Expo
4,802
27

Talk by Gabrielle Roth

https://www.socallinuxexpo.org/scale/...

If you're managing multiple datastores and want to Just Use Postgres, foreign data wrappers are a good option. There are loads of them available, for nearly every datastore you can think of, and you can write your own if you can't find what you're looking for.This mostly-demo talk showcases file_fdw, which allows you to query local resources from your database, and postgres_fdw, which allows you to query other postgres databases. I'll cover use (and mis-use) cases, configuration of each, and interesting quirks.


Watch video Foreign Data Wrappers: Accessing External Data from a PostgreSQL database online without registration, duration hours minute second in high quality. This video was added by user Southern California Linux Expo 20 March 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,802 once and liked it 27 people.