Re: Backing up views, functions

From: Bricklen Anderson <banderson(at)presinet(dot)com>
To: Benjamin Arai <barai(at)cs(dot)ucr(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up views, functions
Date: 2005-12-08 15:07:48
Message-ID: 43984C44.5020803@presinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?
>
> Benjamin
>
This has come up before, if you search the archives, you'll find various
ways of accomplishing this.
Here's a start (one way of getting function source)
http://archives.postgresql.org/pgsql-general/2005-10/msg01633.php

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bricklen Anderson 2005-12-08 15:32:47 Re: Backing up views, functions
Previous Message Guillaume 2005-12-08 13:55:44 pg_dumpall problems with Postgresql 7.4