am Fri, dem 28.03.2008, um 2:08:17 -0700 mailte ajcity folgendes: > > > 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?
Local file systems, and the user postgres needs write-access. I'm using /tmp/... for such. And yes: COPY from a select works only for 8.2 up, not for 8.1. Create a table via 'create table as select ...' and COPY this table. > And what if the psql clients are different (local: 8.1.5 remote:8.2.6)? no matter Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
