search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
523 stars 161 forks source link

How to change foreign table into table？ #184

Open guzicheng90 opened 5 years ago

guzicheng90 commented 5 years ago

I have some trouble in using foregin table，i wanna change foreign table into common table, could i？

slava-pagerduty commented 4 years ago

create table my_table as select * from foreign_table ? you can also put materialized view on top of foreign table to help with refresh, but I don't think you can make a foreign table into Postgres table since foreign table resides at external server and so data needs to be copied over to Postgres.