Thanks all. The COPY command seems to do the work.
One more thing, say I want the data dumped on a remote machine rather than
on the current machine, how would I do that without having to first dump it
on the local machine then uploading to the remote machine?
View this message in context: http://www.nabble.com/Need-help-on-how-to-backup-a-table-tp16346381p16347825.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
In response to
pgsql-general by date
|Next:||From: ashish||Date: 2008-03-28 08:45:51|
|Subject: Re: Need help on how to backup a table|
|Previous:||From: A. Kretschmer||Date: 2008-03-28 08:34:15|
|Subject: Re: PL/pgSQL Documentation, biblio, etc|