Re: How to copy database

Hi !

One way is to:

#pg_dump -c employee_db > employee_dump_c

then

#createdb employee_release

and

#cat employee_dump_c | psql employee_release

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