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
[EMAIL PROTECTED]
602-604-3100 x242


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to