[EMAIL PROTECTED] (ctrl) wrote in message news:<[EMAIL PROTECTED]>...
> I need to copy data that I have on a table in one Postgres database
> into another table, on a different database. The destination table is
> not identical with the source table so I need to do some mapping
> between the 2 tabl
I've got a 3D matrix stored in a table. I'd like to pull back just 2
of the dimensions (specifying a constant value for the 3rd dimension).
e.g.
table1
==
matrix1[5][10][20]
I've like to get matrix[1][all][all] and have it pulled back as a 2D
matrix (new_matrix1[all][all]).
Any way to do th
Ok. I found the libpq syntax for COPY in the Programmer's manual. I've
got a working version, but wanted to verify something.
PQexec(conn, "COPY foo FROM STDIN");
PQputline(conn, "3\thello world\t4.5\n");
PQputline(conn,"4\tgoodbye world\t7.11\n");
...
PQputline(conn,"\\.\n");
PQendcopy(conn);
1.
I'm attempting to use the COPY command through the libpq C functions.
In the psql command line editor, I'd have the following commands:
COPY testtable FROM stdin WITH DELIMITER ',';
1, 2, 'a', 3, 4
5, 6, 'b', 7, 8
9, 10, 'c', 11, 12
\.
My question is:
Does this all have to be passed as one big
