Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2005-01-13 14:18:27
Subject: Re: Copying a database
Previous:From: Lawrence MoranDate: 2005-01-13 13:35:57
Subject: Copying a database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group