pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@qwest.net>
To: erdenemandal <erdene@teltra.org>
Cc: pgsql-admin@postgresql.org
Subject: Re:
Date: Thu, 08 Jul 2004 10:50:46 -0600
Message-ID: <1089305446.32059.7.camel@localhost.localdomain> (raw)
In-Reply-To: <008401c4628d$0eb72190$a400a8c0@teltra14>
References: <008401c4628d$0eb72190$a400a8c0@teltra14>

On Mon, 2004-07-05 at 06:39, erdenemandal wrote:
> Hello,
> 
>  
> 
> My name is Erdenemandal. I am using PostgreSQL and plpgsql language. I
> am wondering , is it possible to call shell programm from plpgsql
> language. I want to create XML file from Database. 
> 
>  
> 
> I mean I want to use plpgsql language for export settings (in
> database) in XML format.

There are two classes of procedural languages in PostgreSQL, safe and
unsafe.  Safe procedural languages don't do anything with file systems,
email, etc...  plpgsql is one of the safe languages.  Unsafe languages
are allowed to do more dangerous things, like play with the file system
etc...

There's a stub called pl/sh out there somewhere that literally lets you
pretty much just call shell scripts from within postgresql.  Any other
unsafe language will also let you do this, like tcl, perl, or php.




view thread (2+ messages)

Message-ID: <1089305446.32059.7.camel@localhost.localdomain>
Permalink:  ../1089305446.32059.7.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1089305446.32059.7.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: smarlowe@qwest.net, erdene@teltra.org
  Subject: Re: 
  In-Reply-To: <1089305446.32059.7.camel@localhost.localdomain>
  References: <008401c4628d$0eb72190$a400a8c0@teltra14> <1089305446.32059.7.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox