Re: Help with COPY command

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: reina_ga(at)hotmail(dot)com (Tony Reina)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help with COPY command
Date: 2004-04-14 15:42:39
Message-ID: 200404141342.PAA21729@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> 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 assuming that I can put in as many PQputline statements as I
> want to between the PQexec("COPY ... FROM ...") and the terminator
> line. Is that correct? No limit?
>
> 2. Do any of these lines need to be followed by a PQclear(res)? What
> about the first PQexec?
>
> -Tony
>
ad 1. Yes, no limit.
ad 2. I use PQclear following the PQexec.

Regards, Christoph

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony and Bryn Reina 2004-04-14 15:54:14 Re: Help with COPY command
Previous Message Charity M 2004-04-14 13:57:05 Database triggers