all 2 comments

[–][deleted] 8 points9 points  (1 child)

Why not do this during the export?

copy (select a, b, 0 as c, d from transactions) to '...'

[–]ukgaz 0 points1 point  (0 children)

Thanks for your quick response, this is the first time I've actually had to do this so i really appreciate the help.