pg_dump selectively ignores extension configuration tables
| От | Joe Conway |
|---|---|
| Тема | pg_dump selectively ignores extension configuration tables |
| Дата | |
| Msg-id | 513A613D.70803@joeconway.com обсуждение исходный текст |
| Ответы |
Re: pg_dump selectively ignores extension configuration tables
|
| Список | pgsql-hackers |
(reposting" apparently I used a verboten word the firsttime around <sigh>. Sorry for any duplicates) The -t and -n options of pg_dump do not dump anything from an extension configuration table, whereas normal pg_dump will dump the user data. To see what I mean, in psql do (tested on pg9.2): 8<-------------------------- create extension postgis; insert into spatial_ref_sys values(42,'test',42,'foo','bar'); 8<-------------------------- Then in bash do: 8<-------------------------- pg_dump test|grep spatial_ref_sys pg_dump -t spatial_ref_sys test|grep spatial_ref_sys pg_dump -n public test|grep spatial_ref_sys 8<-------------------------- Is this intentional, or oversight, or missing feature? Thanks, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support
В списке pgsql-hackers по дате отправления: