How to delete everything from all tables without dropping the database [duplicate]

Question

Possible Duplicate:
Truncating all tables in a postgres database

How can I delete all data from all tables without dropping the database?

Answer 1

You can use raw connection object to execute SQL statements:

connection = ActiveRecord::Base.connection
connection.tables.each{|t| connection.execute "TRUNCATE #{t}"}

Answer 2

Use the DatabaseCleaner gem.

DatabaseCleaner.strategy = :truncation
DatabaseCleaner.clean

If you absolutely must have this within a rake task, just wrap it up in one yourself.