X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3A40B3CCE88 for ; Fri, 17 Dec 2004 16:42:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44401-03 for ; Fri, 17 Dec 2004 16:42:03 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 948723CCE6C for ; Fri, 17 Dec 2004 16:42:01 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3B7B531959; Fri, 17 Dec 2004 17:42:00 +0100 (MET) From: Andreas Kretschmer X-Newsgroups: pgsql.interfaces Subject: Re: restore a plpgsql function with pg_restore Date: Fri, 17 Dec 2004 17:39:58 +0100 Lines: 17 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Orig-Path: not-for-mail User-Agent: tin/1.5.14-20020917 ("Chop Suey!") (UNIX) (Linux/2.4.18-bf2.4 (i686)) To: pgsql-interfaces@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/38 X-Sequence-Number: 5208 begin "miguel lam" wrote: > Please somebody tell me if pg_restore can really restore a plpgsql function. Yes, if the definition of the function is in the dump created with pg_dump. You can via 'pg_restore test.dump | less' and copy&paste extract the definition of the function. I hope, you have a dump... end Andreas -- Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau- fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)