Re: PostgreSQL or pl/psSQL equivalent to MS SQL Server's - Mailing list pgsql-sql

From scott.marlowe
Subject Re: PostgreSQL or pl/psSQL equivalent to MS SQL Server's
Date
Msg-id Pine.LNX.4.33.0307241130050.25837-100000@css120.ihs.com
Whole thread Raw
In response to PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?  (Trent.Mera@PeopleFirst.com)
List 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.





pgsql-sql by date:

Previous
From: Trent.Mera@PeopleFirst.com
Date:
Subject: PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell?
Next
From: elein
Date:
Subject: Re: obtuse plpgsql function needs