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