Re: Copying a database

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
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 14:18:27
Message-ID: FE7F7618-656D-11D9-8575-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Jan 13, 2005, at 22:35, 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?

http://www.postgresql.org/docs/7.4/interactive/sql-createdatabase.html

See the TEMPLATE part.

> Can it be done through phpPgAdmin?

Not sure if there's a special utility to do so, but it's just straight
up SQL so you can enter it in the SQL section.

Hope that helps.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jeff Eckermann 2005-01-13 14:35:52 Re: Ampersands in the output...
Previous Message Sean Davis 2005-01-13 13:56:26 Re: Copying a database