Re: Backing up views, functions

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