I was checking if the postgres bulk loader step uses the pg_bulkload utility? I doubt, because i read from the wiki that it uses COPY DATA FROM STDIN. Some changes between copy and pg_bulkload are as mentioned here :
so should it be a better option to invoke a shell script from pentaho which runs the pg_bulkload?
P.S. I had another query. . pentaho does not abort if there is an error in inserting a record while using postgres bulk loader any help on this to abort the process if some records fail to insert?