Re: loading and unloading rows

Exactly.  My Informix background is showing.  Is there a way to officially
get this put on a to do list?  I'd be most appreciative of the value this adds.

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.
> >