Extension prevents dumping table? - Mailing list pgsql-admin

From Chander Ganesan
Subject Extension prevents dumping table?
Date
Msg-id 4FAAA41E.8080501@gmail.com
Whole thread Raw
Responses Re: Extension prevents dumping table?
List 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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: FW: pg_dump: schema with OID 2200 does not exist
Next
From: Tom Lane
Date:
Subject: Re: Extension prevents dumping table?