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