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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general