Re: retrieving a previously defined stored procedure from the database?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Celia McInnis" <celia(at)drmath(dot)ca>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: retrieving a previously defined stored procedure from the database?
Date: 2005-05-03 20:43:19
Message-ID: 10764.1115152999@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Celia McInnis" <celia(at)drmath(dot)ca> writes:
> Is there some way to extract the text of a previously defined stored
> procedure from the database? (I just managed to clobber one of my files which
> contained a couple of my plpgsql functions in it.).

"pg_dump -s" is your best bet.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Celia McInnis 2005-05-03 21:06:25 drop if exists
Previous Message Bruno Wolff III 2005-05-03 20:29:08 Re: KEY or INDEX