RE: dumping only table definitions

Поиск
Список
Период
Сортировка
От Kevin Brannen
Тема RE: dumping only table definitions
Дата
Msg-id SN1PR19MB02553982176C7BEC615B5404A44E0@SN1PR19MB0255.namprd19.prod.outlook.com
обсуждение исходный текст
Ответ на Re: dumping only table definitions  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general

On Fri, Jun 29, 2018 at 6:30 PM, Kevin Brannen <KBrannen@efji.com> 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 J) of functions we have. Triggers would be all right if I must, as we only have a few of those.

 

Melvin wrote:

 

> > What I do NOT want are all the millions (not literally but it feels like it J) of functions we have.

 

> It sounds like you would best be served by installing pg_extractor. In essence, it is a super flexible version of pg_dump. You have your choice of exactly what you want to dump.

 

> https://github.com/omniti-labs/pg_extractor

Thanks Melvin, that looks like it would do what I want. If it doesn’t, I’ll try Alvaro’s and Tom’s suggestions.

 

Kevin

This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

В списке pgsql-general по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: dumping only table definitions
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: About "Cost-based Vacuum Delay"