Questions tagged [postgres-fdw]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
77 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
739 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 ...
6
votes
1answer
2k 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 ...