output inserted

[Peter Kroon <plakroon@xxxxxxxxx>]

How to I output the insert in PostgreSQL?

DROP TABLE IF EXISTS a_001;

CREATE TEMP TABLE a_001(

vl text

);

DROP TABLE IF EXISTS a_002;

CREATE TEMP TABLE a_002(

vl text

);

INSERT INTO a_001

OUTPUT INSERTED.* INTO a_002 --mssql

SELECT 'text for insertion';

SELECT vl FROM a_002;