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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster