Re: running script on the server

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: running script on the server
Дата
Msg-id 55B8516B.9080901@aklaver.com
обсуждение исходный текст
Ответ на running script on the server  (hamann.w@t-online.de)
Ответы Re: [SOLVED] running script on the server  (hamann.w@t-online.de)
Список pgsql-general
On 07/28/2015 08:28 PM, hamann.w@t-online.de wrote:
>
> Hi,
>
> can any of the programming languages (perl, tcl) be used to exec a process on the server
> and open files?

You are looking for untrusted.

For Python that is the only way it comes, hence plpythonu(ntrusted)

For Perl see here:

http://www.postgresql.org/docs/9.4/interactive/plperl-trusted.html

That is all I know about.

> The scenario I have in mind would
> - copy some fields of a table to an external text file
> - have a script generate binary data from the text file

So what exactly does the above step entail?

Just wondering if it could be done without leaving the database?

> - load that data into a large object
> The client would just
> select rebuild()
>
> Best regards
> Wolfgang Hamann
>
> --
>
>
> gpg key: 92FCFB25
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: hamann.w@t-online.de
Дата:
Сообщение: running script on the server
Следующее
От: John McKown
Дата:
Сообщение: Re: running script on the server