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/