Search Postgresql Archives

Re: running script on the server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 07/28/2015 08:28 PM, hamann.w@xxxxxxxxxxx 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@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux