Re: running script on the server - Mailing list pgsql-general

From Adrian Klaver
Subject Re: running script on the server
Date
Msg-id 55B8516B.9080901@aklaver.com
Whole thread Raw
In response to running script on the server  (hamann.w@t-online.de)
Responses Re: [SOLVED] running script on the server
List 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 by date:

Previous
From: hamann.w@t-online.de
Date:
Subject: running script on the server
Next
From: John McKown
Date:
Subject: Re: running script on the server