Re: Backing up views, functions - Mailing list pgsql-admin

From Bricklen Anderson
Subject Re: Backing up views, functions
Date
Msg-id 4398521F.7040001@presinet.com
Whole thread Raw
In response to Backing up views, functions  (Benjamin Arai <barai@cs.ucr.edu>)
List 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
>
Also, one way of recreating views:

select 'drop view '||viewname||'; CREATE OR REPLACE view '||viewname||'
as '||definition||'\n' from pg_views where schemaname='public';

pgsql-admin by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: Backing up views, functions
Next
From: Guido Barosio
Date:
Subject: the time for pgsql-starting@postgresql.org has come?