Dear people,

How do I use the copy command to copy a whole database
onto a system file so that i can use the createdb with
the -T flag to re-create the database on another
system ?

I have been searching around on the docs but it
doesn't explain much about this ?

Thank you in advance.



__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Low Kian Seong <postgresql_low@yahoo.com> writes:
> How do I use the copy command to copy a whole database
> onto a system file so that i can use the createdb with
> the -T flag to re-create the database on another
> system ?

I think you are looking for pg_dump, not COPY.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings