Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects
Database Blog
This article discusses using the MySQL Foreign Data Wrapper (mysql_fdw) extension in PostgreSQL to query and interact with MySQL and MariaDB databases across different Amazon RDS and Aurora environments.
- Allows importing entire database schemas or selective tables between PostgreSQL and MySQL
- Supports creating foreign tables with subset of columns from remote databases
- Enables writing data to remote MySQL databases through foreign tables
- Provides options for materializing foreign tables to improve query performance
- Supports creating views on top of foreign tables and vice versa
The extension facilitates cross-database operations, data integration, and migration between PostgreSQL and MySQL/MariaDB databases with minimal complexity.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
2025
2026
2024
2024
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.