pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?
3+ messages / 2 participants
[nested] [flat]
* PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?
@ 2003-07-24 15:52 Trent.Mera@PeopleFirst.com
0 siblings, 0 replies; 3+ messages in thread
From: Trent.Mera@PeopleFirst.com @ 2003-07-24 15:52 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?
@ 2003-07-24 17:29 Trent.Mera@PeopleFirst.com
0 siblings, 1 reply; 3+ messages in thread
From: Trent.Mera@PeopleFirst.com @ 2003-07-24 17:29 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL or pl/psSQL equivalent to MS SQL Server's
@ 2003-07-24 17:31 scott.marlowe <scott.marlowe@ihs.com>
parent: Trent.Mera@PeopleFirst.com
0 siblings, 0 replies; 3+ messages in thread
From: scott.marlowe @ 2003-07-24 17:31 UTC (permalink / raw)
To: Trent.Mera@PeopleFirst.com; +Cc: pgsql-sql
On Thu, 24 Jul 2003 Trent.Mera@PeopleFirst.com wrote:
> 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.
That can only be done inside an untrusted procedural language. plpgsql is
trusted, so it can't do that type of thing.
C, pltclu, plprelu, and, as of 7.4 plpython will let you do that.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-07-24 17:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-24 15:52 PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Trent.Mera@PeopleFirst.com
2003-07-24 17:29 PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Trent.Mera@PeopleFirst.com
2003-07-24 17:31 ` Re: PostgreSQL or pl/psSQL equivalent to MS SQL Server's scott.marlowe <scott.marlowe@ihs.com>
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