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