Skip site navigation (1) Skip section navigation (2)

Re: Backup aggregate function

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Victor Jason <vctrjsn(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Backup aggregate function
Date: 2009-09-03 13:11:36
Message-ID: 20090903131136.GB416@eddie (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, Sep 02, 2009 at 09:41:14AM +0300, Victor Jason wrote:
>    Is there a way to backup (dump) a specific aggregate function from the db
>    (in the same manner as using -t option for a single table)?

One method is to use pg_dump -s, which will dump the entire database schema
but none of its data, and then use your favorite text editor to pull out the
definition of just the function you want. There are functions to retrieve the
definition of various system objects (e.g. pg_get_indexdef,
pg_get_constraintdef), but I don't see one for functions.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

In response to

pgsql-novice by date

Next:From: Oliveiros C,Date: 2009-09-03 14:11:50
Subject: Re: Modifying selected records
Previous:From: Ruzsinszky AttilaDate: 2009-09-03 11:44:25
Subject: Re: Modifying selected records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group