Home > mailing lists

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

From	Vish Phaneendra
Subject	Calling a Postgres utility in pgpsql function
Date	June 9, 2009 07:53:19
Msg-id	B0DE296D-A29A-431E-9C14-8B4B84E45E00@greenplum.com Whole thread Raw
Responses	Re: Calling a Postgres utility in pgpsql function
List	pgadmin-support

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

From: sebba
Date: 05 June 2009, 17:01:16
Subject: problemi nell'avvio del server

From: Guillaume Lelarge
Date: 09 June 2009, 07:59:02
Subject: Re: Calling a Postgres utility in pgpsql function