Thread: Simple question for psql
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? Thank You. -- 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 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.