What is Foreign data wrapper?

A PostgreSQL specific feature to allow it access external data sources such as CSV file, MySQL database and etc. Besides, unlike MySQL, PostgreSQL does not natively support accessing different databases in a single statement, to achieve the similar result, user can also setup a PostgreSQL database as a foreign data source.

External reference

Database schema migration and version control, Database CI/CD, and DevOps for developers and DBAs

Bytebase is an open source, web-based database schema change and version control tool for teams. It offers a web-based collaboration workspace to help DBAs and Developers manage the lifecycle of application database schemas.

MySQL
PostgreSQL
Snowflake
Oracle
SQL Server
MongoDB
Redis
Redshift
ClickHouse
TiDB
OceanBase
Spanner
MariaDB
GitLab
GitHub
Bitbucket
Azure DevOps
Terraform
Jira

Features

SQL ReviewMore
Change Propagation & RollbackMore
SQL EditorMore
Dynamic Data MaskingMore
Data Access ControlMore
GitOpsMore
Batch ChangeMore
Schema SynchronizationMore
Index AdvisorMore
Online Schema ChangeMore
RBACMore
SSOMore

What is Foreign data wrapper?

Database schema migration and version control, Database CI/CD, and DevOps for developers and DBAs

Features

Subscribe to Newsletter