Re: Copying a database

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Lawrence Moran <lm511(at)york(dot)ac(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Copying a database
Date: 2005-01-13 13:56:26
Message-ID: EB12A15A-656A-11D9-80C9-000D933565E8@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Lawrence,

Look at:

http://www.postgresql.org/docs/7.4/interactive/app-pgdump.html

In particular, use the --schema-only option.

Sean

On Jan 13, 2005, at 8:35 AM, Lawrence Moran wrote:

> Hi,
>
> I have a simple, flat, empty database I'd like to use as a template
> for others. How can I copy this template to start developing a new
> database? Can it be done through phpPgAdmin?
>
> Thanks,
>
> Lawrence
>
> Lawrence Moran
> Research Associate
> Department of Archaeology
> University of York
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2005-01-13 14:18:27 Re: Copying a database
Previous Message Lawrence Moran 2005-01-13 13:35:57 Copying a database