X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 77192D1C952 for ; Thu, 24 Jul 2003 15:52:57 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 50514-08 for ; Thu, 24 Jul 2003 12:52:11 -0300 (ADT) Received: from a022.peoplefirst.com (unknown [12.22.207.178]) by svr1.postgresql.org (Postfix) with SMTP id 935B8D1C4F1 for ; Thu, 24 Jul 2003 12:52:53 -0300 (ADT) Received: from 10.218.10.13 by a022.peoplefirst.com (InterScan E-Mail VirusWall NT); Thu, 24 Jul 2003 08:52:40 -0700 Received: by a013 with Internet Mail Service (5.5.2653.19) id ; Thu, 24 Jul 2003 08:52:40 -0700 Message-ID: <6032E183529AB142929BB11B0CC23611096EB4D9@a013> From: Trent.Mera@PeopleFirst.com To: pgsql-sql@postgresql.org Subject: PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Date: Thu, 24 Jul 2003 08:52:33 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.5 tagged_above=0.0 required=5.0 tests=HTML_10_20, MIME_BOUND_NEXTPART, NO_REAL_NAME X-Spam-Level: ** Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C351FB.98C786C0" X-Archive-Number: 200307/406 X-Sequence-Number: 14520 ------_=_NextPart_001_01C351FB.98C786C0 Content-Type: text/plain; charset="iso-8859-1" Does anyone know of the PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? This is the command that allows you issue command-line statements from within SQL, e.g., you would do xp_cmdshell 'dir c:\' if you wanted to see the contents of the c: drive. TM ************************************************************************** The information transmitted herewith is sensitive information intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer. ------_=_NextPart_001_01C351FB.98C786C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?</T= ITLE> </HEAD> <BODY> <P><FONT SIZE=3D2 FACE=3D"Arial">Does anyone know of the PostgreSQL or pl/p= sSQL equivalent to MS SQL Server's xp_cmdshell?   This is the com= mand that allows you issue command-line statements from within SQL, e.g., y= ou would do xp_cmdshell 'dir c:\' if you wanted to see the contents of the = c: drive.</FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">TM</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">*****************************************= *********************************</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">The information transmitted herewith is s= ensitive information intended only for use by the individual or entity to w= hich it is addressed. If the reader of this message is not the intended rec= ipient, you are hereby notified that any review, retransmission, disseminat= ion, distribution, copying or other use of, or taking of any action in reli= ance upon this information is strictly prohibited. If you have received thi= s communication in error, please contact the sender and delete the material= from your computer.</FONT></P> </BODY> </HTML> ------_=_NextPart_001_01C351FB.98C786C0--