How to copy a PG database

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

re: How to copy a PG database

Think in terms of

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

"G Lam" <No_spam@anywhere.com> wrote in message
news:5MOdnUmAQJW7RTzfRVn-uQ@comcast.com...[color=blue]
> 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
>
>
>[/color]