On 2009-01-30, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote: > >> 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. not the whole database, you can use --schema-only this can save significant pipe bandwidth. Is it possible to get pg_restore to list just the named function? > 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. but sometimes you only want one of them. in summary it'd be nice to have an equivalent of pg_restore's "--function=NAME(args)" option on pg_dump and to have the "(args)" part optional. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
