Questions tagged [postgres-fdw]
Use this tag when referring to the Postgres module postgres-fdw
3
questions
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 ...
