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]
- [ADMIN] Signal 11 Eric L. Blevins
- Re: [ADMIN] Signal 11 Eric L. Blevins
- Re: [ADMIN] Signal 11 Tom Lane
- Re: [ADMIN] Signal 11 Eric L. Blevins
- Re: [ADMIN] Signal 11 Murthy Kambhampaty
- Re: [ADMIN] loading and unloading rows Naomi Walker
- Re: [ADMIN] loading and unloading rows Bhuvan A
- Re: [ADMIN] loading and unloading rows Naomi Walker
- Re: [ADMIN] loading and unloading... Bruce Momjian
- Re: [ADMIN] loading and unloa... Naomi Walker
- Re: [ADMIN] loading and u... Bruce Momjian
- Re: [ADMIN] loading and u... Naomi Walker
- Re: [ADMIN] loading and u... Bruce Momjian