Re: How to copy database

From: David C(dot)Oshel <dcoshel(at)inav(dot)net>
To: aarni(dot)ruuhimaki(at)kymi(dot)com
Cc: pgsql-novice(at)postgresql(dot)org, Sudheesh Krishnankutty <sudheesh(at)softjin(dot)com>
Subject: Re: How to copy database
Date: 2003-02-17 14:37:31
Message-ID: 58D413A6-4285-11D7-9730-000393051D56@inav.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Monday, February 17, 2003, at 02:24 AM, Aarni Ruuhimäki wrote:

> ...
> #cat employee_dump_c | psql employee_release
>

Or, for dog lovers:

$psql employee_release < employee_dump_c

Couldn't resist :-)
d

> BR,
>
> aarni
>
> On Monday 17 February 2003 10:20 am, you wrote:
>> Dear Admins,
>>
>> I want to make a copy of an existing database.
>> How should I go about doing that. (Say I have an employee database
>> and I want to copy it to employee-release and employee-test.)
>>
>> regards
>>
>> Sudheesh
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
--
David C. Oshel mailto:dcoshel(at)inav(dot)net
Cedar Rapids, Iowa http://soli.inav.net/~dcoshel
``Raffiniert ist der Herrgot, aber boshaft ist er nicht." - A. Einstein

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ben Clewett 2003-02-17 14:47:01 MySQL comparable syntax for PostgreSQL
Previous Message David Härdeman 2003-02-17 14:04:19 Ordering rows in a table