Re: running script on the server

On 07/28/2015 08:28 PM, hamann(dot)w(at)t-online(dot)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(dot)klaver(at)aklaver(dot)com