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 869B2D1C7F0 for ; Thu, 24 Jul 2003 17:29:35 +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 56771-04 for ; Thu, 24 Jul 2003 14:28:50 -0300 (ADT) Received: from a022.peoplefirst.com (unknown [12.22.207.178]) by svr1.postgresql.org (Postfix) with SMTP id C3E08D1C7EB for ; Thu, 24 Jul 2003 14:29:32 -0300 (ADT) Received: from 10.218.10.13 by a022.peoplefirst.com (InterScan E-Mail VirusWall NT); Thu, 24 Jul 2003 10:29:31 -0700 Received: by a013 with Internet Mail Service (5.5.2653.19) id ; Thu, 24 Jul 2003 10:29:31 -0700 Message-ID: <6032E183529AB142929BB11B0CC23611096EB4DC@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 10:29:25 -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_01C35209.209980A0" X-Archive-Number: 200307/361 X-Sequence-Number: 14475 ------_=_NextPart_001_01C35209.209980A0 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_01C35209.209980A0 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_01C35209.209980A0--