Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [postgres-fdw]

Use this tag when referring to the Postgres module postgres-fdw

0
votes
0answers
27 views

How do I create a view across a server using postgres_fdw?

My understanding is that you can query across servers if you use postgres_fdw. I have set this connection up successfully following the official documentation. However, I am struggling to construct ...
2
votes
1answer
611 views

PostgreSQL Foreign Data Wrapper (MSSQL)

I'm trying to do some slow migration from a MS SQL Server 2008 R2 to a PostgreSQL 9.5 + PostGIS. I created a FDW in PostgreSQL to access my MSSQL data and I imported most of my tables, but a few ...
3
votes
1answer
1k views

Import Foreign Schema Fails with “schema postgis does not exist”

I am connecting to a Postgres 9.4 foreign server instance where Postgis 2.1 was installed using CREATE EXTENSION postgis WITH SCHEMA postgis from a Postgres 9.6 Beta where Postgis 2.3dev was installed ...