How to copy a PG database

#1

Hi,
I have a PG database "foodsvc" and I want to make a copy of it with a new
name "newfoodsvc". So that I can play with the "newfoodsve" without any
damage to the "foodsvc".
How can I do that?
Thank you.
GL

#2

Think in terms of

pgdump foodsvc | sed s/foodsvc/newfoodsvc/g | psql

"G Lam" <No_spam (AT) anywhere (DOT) com> wrote

Quote:

Hi,
I have a PG database "foodsvc" and I want to make a copy of it with a new
name "newfoodsvc". So that I can play with the "newfoodsve" without any
damage to the "foodsvc".
How can I do that?
Thank you.
GL

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to copy a PG database

comp.databases.postgresql.general comp.databases.postgresql.general

How to copy a PG database - 06-04-2005 , 11:40 AM

Re: How to copy a PG database - 10-21-2005 , 02:12 AM