Re: Copying a database.

On Jul 20, 2014, at 11:09 AM, maillists0@gmail.com wrote:

> I send a nightly dump of my production database to a development server. A script drops the existing development
databaseand replaces it with the current production copy.  
>
> Each dev uses her own copy of the database. Is there a way to copy the current development database to a differently
nameddb on the same machine, including the data,  without using the sql dump?  

Look at CREATE DATABASE developer_db WITH TEMPLATE production_copy;

createdb with the --template option is a convenient way to do that from the commandline.

Cheers,
  Steve