Postgres Pro
Downloads
Home   >   mailing lists

Re: Calling a Postgres utility in pgpsql function - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: Calling a Postgres utility in pgpsql function
Date
Msg-id 4A2E163D.1010501@lelarge.info
Whole thread Raw
In response to Calling a Postgres utility in pgpsql function  (Vish Phaneendra <vish@greenplum.com>)
Responses Re: Calling a Postgres utility in pgpsql function  ("Sufficool, Stanley" <ssufficool@rov.sbcounty.gov>)
List pgadmin-support
Tree view 
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/pgsql. But you can certainly do that with
untrusted PL like PL/Perlu or PL/Pythonu.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com

pgadmin-support by date:

Previous
From: Vish Phaneendra
Date:
Subject: Calling a Postgres utility in pgpsql function
Next
From: "Sufficool, Stanley"
Date:
Subject: Re: Calling a Postgres utility in pgpsql function