> From: "Tom Lane":
> That's only going to be convenient if the OP periodically wants to
> return to exactly the same database state. If he's doing database
> development, it's probably going to be more like he periodically
> changes the schema and then wants to start over. I suppose he could
> try to remember to apply his schema changes in the template database
> and then clone it, but that seems pretty error-prone.
>
> My thought would be to make use of multi-table TRUNCATE, assuming
> he's using a PG version new enough to have that. Keep a script
> around with a TRUNCATE that lists all of the related tables in one
> command, and just run the script to reset.
Wouldn't using pg_dump with the schema only option accomplish this?
George