Re: [ADMIN] Backing up views, functions

2005-12-08 Thread Bricklen Anderson
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|

Re: [ADMIN] Backing up views, functions

2005-12-08 Thread Bricklen Anderson
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 This has come up before, if you search the archives, you'll find various ways of accomplishing this. Her

Re: [ADMIN] Backing up views, functions

2005-12-07 Thread Michael Fuhr
On Wed, Dec 07, 2005 at 10:53:37PM -0800, 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? pg_dump doesn't allow you to be that selective, but you could use the

[ADMIN] Backing up views, functions

2005-12-07 Thread Benjamin Arai
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives?