psql sqlstate return code access

Hi,

I have a requirement to log into a table the completion code for each statement being submitted in a psql script.

I've looked around and can't seem to find how to access the sqlstate completion code. Is there a system variable in psql available or some other trick to get it?

For example

insert into x select ... from y;

insert into log(message, code,timestamp) values('insert into x',:SQLSTATE,now());

where :SQLSTATE contains the completion code of the prior statement.

Thanks in advance

Doug Little