Skip site navigation (1) Skip section navigation (2)

Extension prevents dumping table?

From: Chander Ganesan <chander(dot)ganesan(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Extension prevents dumping table?
Date: 2012-05-09 17:06:38
Message-ID: 4FAAA41E.8080501@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
With PostGIS 2.0 if I load/install postgis using the command:

create extension postgis schema postgis;

And then use the command:

pg_dump -t postgis.spatial_ref_sys dbname > spatial_ref_sys.sql

I get an output that contains a few "set" statements, but no table 
definition or data from the table.

However, if I install the PostGIS components the "old" way (not using 
the extension loader), the pg_dump of the table works just fine.

Any ideas how to fix this or why this happens?

thanks

chander

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2012-05-09 17:41:13
Subject: Re: Extension prevents dumping table?
Previous:From: Kevin GrittnerDate: 2012-05-09 15:03:53
Subject: Re: FW: pg_dump: schema with OID 2200 does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group