Re: pg_Restore - Mailing list pgsql-general

From Albe Laurenz
Subject Re: pg_Restore
Date
Msg-id A737B7A37273E048B164557ADEF4A58B0579C1CE@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: pg_Restore  (bhanu udaya <udayabhanu1984@hotmail.com>)
Responses Re: pg_Restore  (bhanu udaya <udayabhanu1984@hotmail.com>)
List pgsql-general
bhanu udaya wrote:
> Can you please let me know the procedure for Template. Will it restore the data also
> .

It will create a complete copy of an existing database

The procedure is
CREATE DATABASE newdb TEMPLATE olddb;

Nobody may be connected to olddb for this to work.

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: bhanu udaya
Date:
Subject: Re: pg_Restore
Next
From: Alban Hertroys
Date:
Subject: Re: pg_Restore