On Feb 20, 2008, at 2:12 PM, Douglas McNaught wrote:
>>
>> Alternatively, is there a better way to streamline the duplication
>> of a
>> database?
>
> How about:
>
> CREATE DATABASE newdb TEMPLATE olddb;
The template DB has to have no open connections during the entire copy
process, so it is not always possible when the DB is big and/or busy.
But it is a wonderful way to snapshot development databases before
potentially breaking them with new features. :-)