What is pgsalesforce_fdw?
pgsalesforce_fdw is a Salesforce Foreign Data Wrapper (FDW) for PostgreSQL. It allows you to query live Salesforce data from PostgreSQL. Using it's core functionality, a bi-directional data sync between SF and PG is implemented with upserts and triggers.