Re: Backing up views, functions

From: Bricklen Anderson <banderson(at)presinet(dot)com>
To: Benjamin Arai <barai(at)cs(dot)ucr(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up views, functions
Date: 2005-12-08 15:32:47
Message-ID: 4398521F.7040001@presinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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';

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2005-12-08 15:35:56 the time for pgsql-starting@postgresql.org has come?
Previous Message Bricklen Anderson 2005-12-08 15:07:48 Re: Backing up views, functions