Slightly off subject, is there a way to read from one cluster and insert into a database in another cluster (local or remote)? I think I read this is coming in the future. In Informix-land, we used to do this through a named pipe. It was quite handy.
At 10:39 PM 11/1/02 -0500, Bruce Momjian wrote:
Yes, agreed, it would be nice to have WHERE as part of COPY. In fact, I
like Informix's solution, which merges data in/out with INSERT/SELECT:
UNLOAD TO '/tmp/x'
SELECT *
FROM tab;
and
LOAD FROM '/tmp/x'
INSERT INTO tab;
It is tough to beat this flexibility.
---------------------------------------------------------------------------
Naomi Walker wrote:
>
> The problem with COPY, I think, is that I cannot use a WHERE
> statement. I'd like to just unload certain rows from a table. If I wanted
> the whole table, i'll do a pg_dump or copy.
>
> Again, i'd like a way to easily unload some selected rows (select * table
> where foo=X) from a table, and save them, or load them in another cluster,
> etc. Short of writing them to a temp table, then pg_dumping, or some
> klunk-oid mething, I do not see a clean way.
>
> Back to the maddening crowd. Anyone at least agreed this is needed? Could
> we add "where" clauses to COPY? That would be perfect.
>
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
