The following works as well, for psql;

psql -U "$POSTGRES_USER" -d "$POSTGRES_TARGET"  -c "\copy (SELECT * FROM table) 
TO STDOUT WITH (FORMAT CSV, HEADER, DELIMITER E'\t');" > output.tsv