On Tue, Jul 28, 2015 at 10:28 PM, <haman...@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? > 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 > - load that data into a large object > The client would just > select rebuild() >
Do you want all of the processing to be done on the server side? You need to look into creating an _untrusted_ language such as PL/Tclu, plperlu, or PL/Python (which is always / only untrusted). Those languages allow full access to the TCL, PERL, or Python language, including running other processes (which would run under the postgres UNIX id, not the client's id). http://www.postgresql.org/docs/9.4/static/plpython.html http://www.postgresql.org/docs/9.4/static/plperl-trusted.html http://www.postgresql.org/docs/9.4/static/pltcl-overview.html Just to remind you: THIS CAN BE DANGEROUS TO THE HEALTH OF YOUR SERVER! Your gun. Your ammo. Your foot. Aim carefully. > > Best regards > Wolfgang Hamann > > -- > > > gpg key: 92FCFB25 > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
