Re: [pgadmin-support] Calling a Postgres utility in pgpsql function

2009-06-09 Thread Sufficool, Stanley
This could be done with C if the author of this wonderful utility decided to make it a shared library ;) > -Original Message- > From: pgadmin-support-ow...@postgresql.org > [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of > Guillaume Lelarge > Sent: Tuesday, June 09, 2009 12:5

Re: [pgadmin-support] Calling a Postgres utility in pgpsql function

2009-06-09 Thread Guillaume Lelarge
Vish Phaneendra a écrit : > [...] > Is it possible to call a postgres utility from pgpsql function? I'm > trying to get the table definition using the pgpsql function. > > CREATE FUNCTION table_definition(text) RETURNS text AS $$ > pg_dump -st $1 > $$ LANGUAGE plpgsql; > No, you can't with PL/pg

[pgadmin-support] Calling a Postgres utility in pgpsql function

2009-06-09 Thread Vish Phaneendra
Hi, Is it possible to call a postgres utility from pgpsql function? I'm trying to get the table definition using the pgpsql function. CREATE FUNCTION table_definition(text) RETURNS text AS $$ pg_dump -st $1 $$ LANGUAGE plpgsql; Rgds, Vish