triggers - postgre how to append (COPY ? ) the last inserted row (NEW) to a file

Question

I am trying to create a trigger in a postgre (9.6) database. My goal is to apped the last inserted row to a file. I can make it work by COPYing the whole table with the following code. My questions are : how to append data with COPY ? and how to use only the last inserted row ? Here is my code.

create function test_function() returns trigger as $test_trigger$
  begin
    copy (select * from my_table) to 'C:Tempstats.txt';
    return NEW;
  end;
$test_trigger$ language plpgsql;

create trigger test_trigger after insert on my_table
for each row
execute procedure test_function();

question from:https://stackoverflow.com/questions/65904277/postgre-how-to-append-copy-the-last-inserted-row-new-to-a-file

Answer 1

Waitting for answers