Simple question for psql

On Wednesday, April 23, 2003, at 10:36 PM, Hadley Willan wrote:

Hi all,
How do I show the code for a function?

\d doesn't work against them?

and \df lists them....

I looked at \? and nothing jumped out?

\df+ function_name

-heath

Thanks.

However, I still can't seem to list the pg_catalog functions like
RI_FKey_cascade_del?

Hadley

On Thu, 2003-04-24 at 15:06, Heath Tanner wrote:

On Wednesday, April 23, 2003, at 10:36 PM, Hadley Willan wrote:

Hi all,
How do I show the code for a function?

\d doesn't work against them?

and \df lists them....

I looked at \? and nothing jumped out?

\df+ function_name

-heath

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

--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley.willan@deeperdesign.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.

On Thu, Apr 24, 2003 at 03:15:25PM +1200, Hadley Willan wrote:

Thanks.

However, I still can't seem to list the pg_catalog functions like
RI_FKey_cascade_del?

Those are defined in C in Postgres' source code itself,
in src/backend/utils/adt/ri_triggers.c
(most if not all are in src/backend/utils/adt)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Use it up, wear it out, make it do, or do without"

Okay, I'll check them out.

Thanks
On Thu, 2003-04-24 at 15:27, Alvaro Herrera wrote:

On Thu, Apr 24, 2003 at 03:15:25PM +1200, Hadley Willan wrote:

Thanks.

However, I still can't seem to list the pg_catalog functions like
RI_FKey_cascade_del?

Those are defined in C in Postgres' source code itself,
in src/backend/utils/adt/ri_triggers.c
(most if not all are in src/backend/utils/adt)

--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley.willan@deeperdesign.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.