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

Re: Pet Peeves?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: jd(at)commandprompt(dot)com
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pet Peeves?
Date: 2009-01-30 17:20:37
Message-ID: 498336E5.7050207@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-general
> You can however pull it from a -Fc backup with pg_restore. Just FYI.
>
> Joshua D. Drake
>   

Or strip it from a pg_dump/pg_dumpall with sed. Or write your own 
function-dumper based on ideas gleaned from various notes/comments on 
the web (my approach).

I had not thought of using the -Fc approach but it appears that that 
would require dumping the whole database then using pg_restore to pull 
the function definition from the dump.

One other thing that would be nice to have for function-dumping whether 
in pg_dump or using the -Fc approach would be the ability to dump all 
functions of a given name instead of having to go one-by-one. It's 
pretty unusual for identically-named functions to have unrelated purposes.

Cheers,
Steve


In response to

Responses

pgsql-general by date

Next:From: Sam MasonDate: 2009-01-30 17:31:55
Subject: Re: Pet Peeves?
Previous:From: Craig RingerDate: 2009-01-30 17:06:50
Subject: Re: Pet Peeves?

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