Re: Substitutes for some Oracle packages - Mailing list pgsql-general

From Sam Mason
Subject Re: Substitutes for some Oracle packages
Date
Msg-id 20090917200413.GV5407@samason.me.uk
Whole thread Raw
In response to Substitutes for some Oracle packages  ("Arnold, Sandra" <ArnoldS@osti.gov>)
Responses Re: Substitutes for some Oracle packages  ("Arnold, Sandra" <ArnoldS@osti.gov>)
List pgsql-general
On Thu, Sep 17, 2009 at 03:53:36PM -0400, Arnold, Sandra wrote:
> We are in the process of migrating from Oracle to PostgreSQL.  One of
> the things that we are needing to find out is what to use in place of
> Oracle supplied functionality such as "DBMS_OUTPUT" and "UTL_FILE".

For those of us who use PG and not Oracle a description of the
functionality you need would help, the artifacts of your current
implementation are less helpful.  That said:

  plpgsql can RAISE NOTICE, which looks similar to DBMS_OUTPUT

  most "untrusted" scripting languages (i.e. plperl or plpython) can
  touch the filesystem, which is what UTL_FILE seems to be about

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: 'Weird' errors
Next
From: Scott Marlowe
Date:
Subject: Re: limiting query time and/or RAM