Hi all,

I am using Postgresql 7.4.3 on Linux 7.2.
In my project i am using many user defined functions. All the functions are
working fine, no problem with the working. I had stored all the functions in
the /home/postgres folder on the linux machine. I used psql -f -filename
-databasename command to run the functions. Last night, I accidentally
deleted the source files from the /home/postgres folder. I dont have the
backup of these functions. However these functions are working fine. Is
there a way to view the sourcecode of the functions from the database.
When I type the command,

eps_db=# \df

it gives the list of all the functions used in the database(eps_db),
arguments passed and the function return type. Is there a way wherein I can
look into the function sourcecode from within the database.

Thanks in advance.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo (AT) honeywell (DOT) com> writes:
\df+ ... but really what you want to do is run pg_dump (possibly with -s
option) to extract the function definitions in a reloadable form.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

That worked, Thanks a lot Tom.


-----Original Message-----
From: Tom Lane [mailto:tgl (AT) sss (DOT) pgh.pa.us]
Sent: Tuesday, August 31, 2004 11:30 AM
To: Pradeepkumar, Pyatalo (IE10)
Cc: pgsql-novice (AT) postgresql (DOT) org
Subject: Re: [NOVICE] viewing function source code


"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo (AT) honeywell (DOT) com> writes:
\df+ ... but really what you want to do is run pg_dump (possibly with -s
option) to extract the function definitions in a reloadable form.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings