Re: Need help on how to backup a table - Mailing list pgsql-general

ashish-21 wrote:
>
> ajcity wrote:
>> If I wanted to use that with a command like "COPY (SELECT * FROM country
>> WHERE country_name LIKE 'A%') TO '<filename>'; " do I specify the file
>> location for the remote machine as the <filename> or do I specify the
>> location for local machine?
>>  And what if the psql clients are different (local: 8.1.5  remote:8.2.6)?
>>
>>   Thanks
>>   Victor
>>
>>
>
> from remote m/c
> psql -h some_hostname -c "copy temp to stdout" -Upostgres postgres >
> temp.txt
>
> Will create temp file on the m/c from which u r firing the command .
>
> With regards
> Ashish
>
>

  Thanks all
   I tried this option and it worked PERFECTLY.
   Thanks every body.

   Victor

--
View this message in context: http://www.nabble.com/Need-help-on-how-to-backup-a-table-tp16346381p16352647.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.