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
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
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