Re: loading and unloading rows - Mailing list pgsql-admin

Can we add unload/load functionality to the list, please?



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