From erdene@teltra.org Mon Jul 5 12:38:58 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E45A5D1B258 for ; Mon, 5 Jul 2004 09:38:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77989-05 for ; Mon, 5 Jul 2004 12:38:57 +0000 (GMT) Received: from web12.manitu.net (web12.manitu.net [217.11.48.112]) by svr1.postgresql.org (Postfix) with ESMTP id 7E28DD1B18F for ; Mon, 5 Jul 2004 09:38:53 -0300 (ADT) Received: from teltra14 (dsl-082-083-142-120.arcor-ip.net [82.83.142.120]) by [217.11.49.109] (8.10.2-SOL3/8.10.2) with ESMTP id i65CcsC11649 for ; Mon, 5 Jul 2004 14:38:54 +0200 From: "erdenemandal" To: Subject: Date: Mon, 5 Jul 2004 14:39:01 +0200 Message-ID: <008401c4628d$0eb72190$a400a8c0@teltra14> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0085_01C4629D.D23FF190" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_70_80, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200407/104 X-Sequence-Number: 14172 This is a multi-part message in MIME format. ------=_NextPart_000_0085_01C4629D.D23FF190 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, =20 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.=20 =20 I mean I want to use plpgsql language for export settings (in database) in XML format. =20 Plese give me advice, how can I solve this problem.=20 =20 I am using VB. NET for application.=20 =20 =20 =20 =20 Mit freundlichen Gr=FC=DFen, ________________________________ Erdenemandal Bat-Erdene Teltra GmbH Ermlandstra=DFe 29 44789 Bochum Tel: +49(0)234/ 33 36 93 3 Fax: +49(0)234/ 93 53 98 93 E-Mail: erdene@teltra.de =20 ------=_NextPart_000_0085_01C4629D.D23FF190 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,<= /font>

 <= /font>

My name is Erdenemandal. = I am using PostgreSQL and plpgs= ql language. I am wondering , is it possible to call shell programm from plpgsql language. I want to create XML fil= e from Database.

 <= /font>

I mean I want to use plpgsql language for export settings (in database) in= XML format.

 <= /font>

Plese<= /span> give me advice, how can I solve this problem.

 <= /font>

I am using VB. NET for application.

 <= /font>

 <= /font>

 <= /font>

 <= /font>

Mit freundlichen Gr=FC=DFen,

________________________________

Erdenemandal Bat-Erdene
Teltra GmbH
Ermlandstra=DFe 29
44789 Bochum

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

 



____________
Virus checked by G DATA AntiVirusKit
Version: AV= K 14.0.1315 from 02.07.2004
Virus news: www.antiviruslab.com
------=_NextPart_000_0085_01C4629D.D23FF190-- From smarlowe@qwest.net Thu Jul 8 16:49:48 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 41561D1B26C for ; Thu, 8 Jul 2004 13:49:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63166-06 for ; Thu, 8 Jul 2004 16:49:47 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id DFD17D1B260 for ; Thu, 8 Jul 2004 13:49:44 -0300 (ADT) Received: (qmail 77332 invoked by uid 0); 8 Jul 2004 16:49:44 -0000 Received: from mpls-pop-04.inet.qwest.net (63.231.195.4) by mpls-qmqp-04.inet.qwest.net with QMQP; 8 Jul 2004 16:49:44 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-04.inet.qwest.net with SMTP; 8 Jul 2004 16:49:44 -0000 Date: Thu, 08 Jul 2004 10:50:46 -0600 Message-Id: <1089305446.32059.7.camel@localhost.localdomain> From: "Scott Marlowe" To: "erdenemandal" Cc: pgsql-admin@postgresql.org Subject: Re: In-Reply-To: <008401c4628d$0eb72190$a400a8c0@teltra14> References: <008401c4628d$0eb72190$a400a8c0@teltra14> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/108 X-Sequence-Number: 14176 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.