On Tuesday, April 05, 2011 4:19:56 pm Raymond O'Donnell wrote: > On 06/04/2011 00:15, Greg Corradini wrote: > > Hello, > > Is it possible yet in 8.4 to pg_dump specific functions without having > > to do the whole pg_restore thing? > > If I understand correctly what you're trying to do, a handy alternative > is to use pgAdmin, right click on the function in the tree view, and > select Scripts -> Create. > > Ray.
In addition, from inside psql do \ef function_name. This opens the function in an editor from which you can save it elsewhere. If you are talking a lot of functions then you can use the -l and -L options to pg_restore to create a TOC list that can be edited to contain only the functions you want. These than can either be restored to a database or file. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
