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