Exception handling: Oracle's "SQLERRM" keyword option?

["Dinesh Pandey" <dpandey@xxxxxxxx>]

Hi,

 

I have installed PostgreSQL 8.0.1 on Solaris 9.

 

I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language.

 

In Oracle we can get error message from "SQLERRM" keyword and insert messages into log table.

 

How can I get error message/error code in PostgreSQL after an EXCEPTION or RAISE EXCEPTION occurs in EXCEPTION block??

 

Pls help me or send me some example.

 

 

Thanks

Dinesh Pandey