Keith Fiske <keith@xxxxxxxxxx> writes: > I've read the documentation for extensions and how their data is not > normally dumped by pg_dump and how to configure the table so it should > dump its data > http://www.postgresql.org/docs/9.1/static/extend-extensions.html > However, after setting this option for the tables, the data is not > being dumped when I do a pg_dump of either individual tables or the > schema I've installed the extension to. IIRC, the design intention is that such a table's data would be dumped when (and only when) the extension is dumped. That is, I'd expect to see a "CREATE EXTENSION foo;" and then data for the extension's tables. The partial-dump scenarios you mention wouldn't dump extensions, hence not extension table data either. Whether this design is a good one is still under debate, but I think pg_dump is operating as designed here ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
