Re: dumping only table definitions
От
Alvaro Herrera
Тема
Re: dumping only table definitions
Дата
Msg-id
20180629223949.tdifrvvqejuqyl2i@alvherre.pgsql
Ответ на
dumping only table definitions (Kevin Brannen)
Список
Дерево обсуждения
dumping only table definitions Kevin Brannen <KBrannen@efji.com>
Re: dumping only table definitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: dumping only table definitions Tom Lane <tgl@sss.pgh.pa.us>
Re: dumping only table definitions Vick Khera <vivek@khera.org>
Re: dumping only table definitions Melvin Davidson <melvin6925@gmail.com>
RE: dumping only table definitions Kevin Brannen <KBrannen@efji.com>
On 2018-Jun-29, Kevin Brannen wrote: > I'm trying to figure out how to dump only the table definitions, well those and things they need directly, like sequences & types. What I do NOT want are all the millions (not literally but it feels like it :)) of functions we have. Triggers would be all right if I must, as we only have a few of those. Try "pg_dump -Fc" followed by pg_restore -l. You can edit the list emitted there, then use it with pg_restore -L. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-general по дате отправления
