Re: [SQL] Viewing stored procedure code

2002-10-10 Thread Achilleus Mantzios
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.

[SQL] Viewing stored procedure code

2002-10-10 Thread Ludwig Lim
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! htt