Re: Calling a Postgres utility in pgpsql function

Поиск
Список
Период
Сортировка
От Sufficool, Stanley
Тема Re: Calling a Postgres utility in pgpsql function
Дата
Msg-id C2F174F99918D54CA2A96E57C5079B6F015C3B7A@sbc-exmsg2.sbcounty.gov
обсуждение исходный текст
Ответ на Re: Calling a Postgres utility in pgpsql function  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
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-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Guillaume Lelarge
> Sent: Tuesday, June 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 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.org
>  http://dalibo.com
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>


В списке pgadmin-support по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Calling a Postgres utility in pgpsql function
Следующее
От: "Andreas Nolte"
Дата:
Сообщение: Bug with 1.10.0 Beta 4