Thread: EXCEPTION handling in PL/pgSQL.

EXCEPTION handling in PL/pgSQL.

From
"Dinesh Pandey"
Date:
Hi,
 
I am new in Postgres.
 
Can any one tell me best way of EXCEPTION handling in PL/pgSQL.
 
1. I mean How to get Raised Exception messages in "EXCEPTION" block (I mean exception messages thrown by us OR by Postgres SQL Exception).
 
2. Is EXCEPTION datatype is available in Postgres as it is available in ORACLE.
 

Regards
Dinesh Pandey



----------------------------------------------------------------------------------
Dinesh Pandey 
Sr. Software Engineer