When restoring a PostgreSQL dump using pg_restore, you usually add the --clean flag to remove any existing data from tables.

Rails professionals since 2007

Our laser focus on a single technology has made us a leader in this space. Need help?

• We build a solid first version of your product
• We train your development team
• We rescue your project in trouble

Read more Show archive.org snapshot

Note that this only removes data from tables that are part of the dump and will not remove any extra tables. You need to do that yourself.