search

pgspider / jdbc_fdw

JDBC Foreign Data Wrapper for PostgreSQL
Other
58 stars 20 forks source link

can support greenplum？ #37

Open wonb168 opened 2 months ago

JosefMachytkaNetApp commented 1 month ago

Greenplum claims to be "Massively Parallel PostgreSQL". Maybe you can simply use postgres_fdw?

wonb168 commented 1 month ago

I want query rdb in gp，not only postgres，so postgres_fdw not enough

JosefMachytkaNetApp commented 1 month ago

Still, if Greenplum is PostgreSQL and allows you to use FDW extensions, then PostgreSQL has multiple FDW for diffferent databases, only difference will be in creating extension and foreign server. I have such solution for multiple databases and it works.