Postgres Pro
Downloads
Home   >   mailing lists

Re: retrieving a previously defined stored procedure from the database? - Mailing list pgsql-novice

From Tom Lane
Subject Re: retrieving a previously defined stored procedure from the database?
Date
Msg-id 10764.1115152999@sss.pgh.pa.us
Whole thread Raw
In response to retrieving a previously defined stored procedure from the database?  ("Celia McInnis" <celia@drmath.ca>)
Responses drop if exists  ("Celia McInnis" <celia@drmath.ca>)
List pgsql-novice
Tree view 
"Celia McInnis" <celia@drmath.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

pgsql-novice by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: Can't Use DB As Template - accessed by other users error
Next
From: "Celia McInnis"
Date:
Subject: drop if exists