Re: How to dump JUST procedures/funnctions?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to dump JUST procedures/funnctions?
Дата
Msg-id 15756.1269259419@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to dump JUST procedures/funnctions?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список pgsql-general
"Carlo Stonebanks" <stonec.register@sympatico.ca> writes:
>> Afaik no, you can make a schema-dump and extract the function
>> declarations from the dump.

> Yeah, that's what I was doing. Bloody tedious. Thanks anyway!

It seems like it could be automated.

    pg_dump -Fc -s mydb >mydb.dump
    pg_restore -l mydb.dump | grep FUNCTION >mydb.list
    pg_restore -L mydb.list mydb.dump >functionsonly.txt

(or something more or less like that --- too early in the morning...)

            regards, tom lane

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

Предыдущее
От: Carsten Kropf
Дата:
Сообщение: Determining the OID of a certain type
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Determining the OID of a certain type