ssh dbuser@hostname "echo \"SELECT * FROM tabelle;\" | psql -d testdb -U dbuser -A -F $'\t'" | psql -d testdb -U dbuser -c "COPY tabelle FROM STDIN WITH (FORMAT csv, DELIMITER E'\t', HEADER MATCH);"
oder
ssh dbuser@hostname "echo \"SELECT * FROM tabelle;\" | psql -d testdb -U dbuser -A -F $'\t'" | psql -d testdb -U dbuser -c "COPY tabelle FROM STDIN WITH (FORMAT csv, DELIMITER E'\t', HEADER MATCH, NULL '');"