PostgreSQL, PostGIS: Copying a schema with a geometry column
2
votes
1
answer
862
views
According to the PostGIS manual , geometry columns should not by added directly, but using AddGeometryColumn() :
> AddGeometryColumn — Adds a geometry column to an existing table of
> attributes.
I am copying a schema from one PostgreSQL instance to another. I wonder if the SQL created by
pg_dump
is good enough - will it create the geometry columns the same way AddGeometryColumn() does?
Asked by Adam Matan
(12079 rep)
Jul 17, 2014, 04:32 PM
Last activity: Jul 17, 2014, 07:46 PM
Last activity: Jul 17, 2014, 07:46 PM