suggestion for backup - Mailing list pgsql-general

From c k
Subject suggestion for backup
Date
Msg-id CAN2Y=uP90_Cysgmrkr84XqieCoyw1YaLYNCAGqmqNnM=H9Q3Kg@mail.gmail.com
Whole thread Raw
Responses Re: suggestion for backup
List pgsql-general
Hi,
In day to day work I need to dump objects of only specific types like functions, types, view etc from a schema. I know that it will be better to use separate schemas for  similar tasks and already using it. This problem arises when I have to issue an update script to the client having only function mostly. And as most of the functions are dependent on others and having more than 1100 functions it becomes hard to write a list of objects for pg_dump.
So I suggest to provide a feature in pg_dump/pg_dumpall to backup only specific type of objects like tables, functions etc. It will be very useful for users who are in database development.

thanks,

C P Kulkarni

pgsql-general by date:

Previous
From: Clemens Eisserer
Date:
Subject: Re: Reasons for postgres processes beeing killed by SIGNAL 9?
Next
From: Chris Angelico
Date:
Subject: IN vs equality (was Re: odd intermittent query hanging issue)