Re: Dumping functions with pg_dump

Поиск
Список
Период
Сортировка
От Greg Corradini
Тема Re: Dumping functions with pg_dump
Дата
Msg-id BANLkTimgrhwg=E_+wXSwoFYeq843nocu6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dumping functions with pg_dump  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
Thanks for the reply Raymond!

This is all through remote terminal so I can't use pg_admin ;(

Maybe some more quick context.... I don't want to dump whole database b/c the thing is 12GB and for the application we're building we only access certain tables in the DB. There's one table that has two triggers associated to it, each which in turn references it's own procedure.

So my pg_dump syntax has a lot of -t <table_name> -t<table_nameII> in it to target only the tables I want. But the procedures tied to the triggers aren't coming with it unless I do the whole dump.

thx

On Tue, Apr 5, 2011 at 4:19 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 06/04/2011 00:15, Greg Corradini wrote:
Hello,
Is it possible yet in 8.4 to pg_dump specific functions without having
to do the whole pg_restore thing?

If I understand correctly what you're trying to do, a handy alternative is to use pgAdmin, right click on the function in the tree view, and select Scripts -> Create.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



--
Greg

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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Dumping functions with pg_dump
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Dumping functions with pg_dump