Postgres backup by pg_dump and psql restore

pg_dump –data-only -t “\”MixedCaseName\”” > xxx.txt
(add -o if you want to retain id)

Use psql to delete all data from the table.

sudo sudo -u username psql -U username -d dbname -f filename(xxx.txt)