Re: Need help on how to backup a table

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