Postgres Pro
Downloads
Home   >   mailing lists

Thread: Fw: libpq or Embedded SQL in C

Fw: libpq or Embedded SQL in C

From
"Thuan Truong"
Date:
 
All,
 
I need to upload (insert) a flat file to PostgresSQL DB (on Solaris 9) using C.  I wonder if I should use libpq functions or embedded SQL in C (libecpg).  Any help is appreciated.  If you have any sample programs, please send along.
 
Thanks,
Andy Truong
 

Re: Fw: libpq or Embedded SQL in C

From
"Dann Corbit"
Date:
You may be able to use the COPY command, which would probably be a lot faster.
 
 
There are sample programs in the INTERFACES subdirectory for each of the interface types.
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thuan Truong
Sent: Tuesday, August 17, 2004 2:42 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Fw: libpq or Embedded SQL in C

 
All,
 
I need to upload (insert) a flat file to PostgresSQL DB (on Solaris 9) using C.  I wonder if I should use libpq functions or embedded SQL in C (libecpg).  Any help is appreciated.  If you have any sample programs, please send along.
 
Thanks,
Andy Truong
 

Re: Fw: libpq or Embedded SQL in C

From
"Thuan Truong"
Date:
Thanks, Dann.  Let me try and will let you know. 
 
Andy
----- Original Message -----
Sent: Tuesday, August 17, 2004 7:26 PM
Subject: Re: [GENERAL] Fw: libpq or Embedded SQL in C

You may be able to use the COPY command, which would probably be a lot faster.
 
 
There are sample programs in the INTERFACES subdirectory for each of the interface types.
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thuan Truong
Sent: Tuesday, August 17, 2004 2:42 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Fw: libpq or Embedded SQL in C

 
All,
 
I need to upload (insert) a flat file to PostgresSQL DB (on Solaris 9) using C.  I wonder if I should use libpq functions or embedded SQL in C (libecpg).  Any help is appreciated.  If you have any sample programs, please send along.
 
Thanks,
Andy Truong