pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
(no subject)
2+ messages / 2 participants
[nested] [flat]

* (no subject)
@ 2004-07-05 12:39 erdenemandal <erdene@teltra.org>
  2004-07-08 16:50 ` Re: Scott Marlowe <smarlowe@qwest.net>
  0 siblings, 1 reply; 2+ messages in thread

From: erdenemandal @ 2004-07-05 12:39 UTC (permalink / raw)
  To: pgsql-admin

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.
 
Plese give me advice, how can I solve this problem. 
 
I am using VB. NET for application. 
 
 
 
 
Mit freundlichen Grüßen,

________________________________

Erdenemandal Bat-Erdene
Teltra GmbH
Ermlandstraße 29
44789 Bochum

Tel: +49(0)234/ 33 36 93 3
Fax: +49(0)234/ 93 53 98 93
E-Mail: erdene@teltra.de
 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re:
  2004-07-05 12:39 (no subject) erdenemandal <erdene@teltra.org>
@ 2004-07-08 16:50 ` Scott Marlowe <smarlowe@qwest.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2004-07-08 16:50 UTC (permalink / raw)
  To: erdenemandal <erdene@teltra.org>; +Cc: pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-08 16:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-05 12:39  erdenemandal <erdene@teltra.org>
2004-07-08 16:50 ` Re: Scott Marlowe <smarlowe@qwest.net>

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