Re: Backing up views, functions

[Bricklen Anderson <banderson@xxxxxxxxxxxx>]

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';