Recreate test db from development db in rails/postgresql?

Question

strong textActually I'm using pgAdmin to manage PostgreSQL development database in a rails application.

I've defined the following constraints on USERS table:

 CONSTRAINT users_pkey PRIMARY KEY (id ),
 CONSTRAINT users_name_key UNIQUE (name ),
 CONSTRAINT users_age_check CHECK (age > 16),

But when I do rake:db:test:clone the test database copy the development structure except the above constraints.

Answer 1

Is it really necessary to clone your DB with Ruby? Isn't it easier to create your clone from within Postgres using create Db with template?