On Thu, 10 Oct 2002, Ludwig Lim wrote: > Hi : > > 1) How do I view the body of a stored procedure in > psql?
SELECT prosrc from pg_proc where proname = 'your pl/pgsql procedure name'; > > 2) How do I know get the corresponding stored > procedure of a particular trigger in psql? > SELECT t.tgname,f.proname from pg_trigger t,pg_proc f where t.tgname = 'your trigger name' and t.tgfoid = f.oid; > thanks in advance, > > ludwig. > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
