Questions tagged [postgres-fdw]

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

Filter by
Sorted by
Tagged with
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 ...