Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)

On Wednesday, August 29, 2012 05:41:07 PM Willy-Bas Loos wrote:
> On Wed, Aug 29, 2012 at 5:23 PM, Andres Freund
<andres@2ndquadrant.com>wrote:
> > That shouldn't be a problem with postgres 2 anymore as far as I
> > understand things?
Argh, postgis 2.

Two things:
* the geometry_columns table is not a table anymore but a view of the postgres
catalogs
* extensions (9.1+, used by postgis 2 onwards) can declare configuration
tables now, so even if you would still need a configuration table it would get
dumped in a schema only dump

Also, adding postgis support into pg_dump would have been problematic given
that pg_dump is part of core postgres and postgis isnt...

Andres


--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services