Pg_restore
Pg_restore overwrite
Questions in this topic
How do I view PostgreSQL databases?
Why truncate is faster than delete?