This might sound silly, but I am trying something basic, and having
trouble. What I want to do is unload selected rows from a table, and load
them somewhere else.
pg_dump works great if you want the whole table. I suppose I could from
one table, dump into a temp, and then pg_dump it, but that seems silly.
I noticed in the pg_dump unloaded looking rows, with a:
COPY "table" FROM stdin;
before the rows.
So, I ran psql, did a \o to capture the output,
did a select * from table where x=y
whacked the first row in the output file, and added the COPY statement.
then did a psql dbname <file-with-rows.sql
The first column loaded, but the rest of the columns did not. I noticed
there were | delimiters in my unloaded one, and none in a pg_dump file.
This seems way too klunky, so I must be going about it all wrong. In
Informix-land I would just do a unload then a load. What is the postgresql
equivalent?
Suggestions?
Thanks,
Naomi
----------------------------------------------------------------------------
----------------------------------
Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
nwalker@eldocomp.com
602-604-3100 x242