pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Viewing stored procedure code 2+ messages / 2 participants [nested] [flat]
* Viewing stored procedure code @ 2002-10-10 07:27 Ludwig Lim <lud_nowhere_man@yahoo.com> 2002-10-10 09:01 ` Re: Viewing stored procedure code Achilleus Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 1 reply; 2+ messages in thread From: Ludwig Lim @ 2002-10-10 07:27 UTC (permalink / raw) To: pgsql-sql Hi : 1) How do I view the body of a stored procedure in psql? 2) How do I know get the corresponding stored procedure of a particular trigger in psql? thanks in advance, ludwig. __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Viewing stored procedure code 2002-10-10 07:27 Viewing stored procedure code Ludwig Lim <lud_nowhere_man@yahoo.com> @ 2002-10-10 09:01 ` Achilleus Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 0 replies; 2+ messages in thread From: Achilleus Mantzios @ 2002-10-10 09:01 UTC (permalink / raw) To: Ludwig Lim <lud_nowhere_man@yahoo.com>; +Cc: pgsql-sql 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: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-10-10 09:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-10-10 07:27 Viewing stored procedure code Ludwig Lim <lud_nowhere_man@yahoo.com> 2002-10-10 09:01 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox