Calling a Postgres utility in pgpsql function

From: Vish Phaneendra <vish(at)greenplum(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Calling a Postgres utility in pgpsql function
Date: 2009-06-09 06:03:42
Message-ID: B0DE296D-A29A-431E-9C14-8B4B84E45E00@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2009-06-09 07:58:53 Re: Calling a Postgres utility in pgpsql function
Previous Message sebba 2009-06-05 16:31:11 problemi nell'avvio del server