Questions tagged [postgres-fdw]
Use this tag when referring to the Postgres module postgres-fdw
3
questions
0
votes
0answers
35 views
Using geography cast as geometry in QGIS No SRID in Airports table. Other table have geom and is 26986
I trying to add a layer into the map in QGIS. It will execute the SQL and show the answer but will not add it to the map. It states there a geometry error. I type cast geom::geography it should allow ...
2
votes
1answer
790 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 ...