Re: Backing up views, functions

On Wed, Dec 07, 2005 at 10:53:37PM -0800, Benjamin Arai wrote:
> I have a database of several million records and we are currently
> developing pl functions and views. How do you dump only the code for
> views and functions?

pg_dump doesn't allow you to be that selective, but you could use
the --schema-only option to dump everything except the data. If
you use one of the non-text dump formats then you could selectively
restore objects with pg_restore. See the pg_restore documentation
for the -l/--list and -L/--use-list options and the example near the
bottom of the page.

Some people maintain the code for functions and views outside the
database, perhaps under a version control system, and then reload
it when they make changes.

--
Michael Fuhr