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

2009-06-09 Thread Sufficool, Stanley
une 09, 2009 12:59 AM > To: Vish Phaneendra > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Calling a Postgres utility in > pgpsql function > > > Vish Phaneendra a écrit : > > [...] > > Is it possible to call a postgres utility from p

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