Re: loading and unloading rows

>
>It is possible. Delimiters can be used while restoring the data file.
>Null string specification can also be specified. See,
>test_db=> \h COPY
>for more details.

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.


>In addition you should also do some find and replace in the data file
>before restoring it to another database. They are,
>s/\s*|\s*//g
>s/^\s*//g

Yes, sed is a fine tool, but this seems like such a fundamental need, i'm
surprised there is not better method.

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.

----------------------------------------------------------------------------
----------------------------------
Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
nwalker@eldocomp.com
602-604-3100 x242