siehe auch: PostgreSQL

aus DB dumpen

for TAB in table1 table2 table3 table4 table5
do
	echo "COPY ${TAB} TO 'export_${TAB}.tsv' WITH (FORMAT csv, DELIMITER E'\t', HEADER true)" | sudo -u postgres psql -d database_name
done

COPY

Ohne Header (mit -t)
  COPY table FROM 'file.tsv' WITH (FORMAT csv, DELIMITER E'\t');
 
Mit Header (ohne -t)
  COPY table FROM 'file.tsv' WITH (FORMAT csv, DELIMITER E'\t', HEADER true);

in DB einspielen

for TAB in table1 table2 table3 table4 table5
do
	echo "COPY ${TAB} FROM 'export_${TAB}.tsv' WITH (FORMAT csv, DELIMITER E'\t', HEADER true);" | sudo -u postgres psql -d database_name
done