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". We are currently using this type of functionality in Stored Procedures and packages. What are the options in PostgreSQL for replacing these two packages in a stored procedure/function?
Thanks,
Sandra Arnold
Sr. DBA
DOE/OSTI
Oak Ridge, TN