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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
