Remote PostgreSQL database - C/C++ program / Unix / Required Libraries

From: Léa Massiot <lmhelp1(at)orange(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries
Date: 2014-11-30 19:44:41
Message-ID: 1417376681167-5828704.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello and thank you for reading my post.

I would like to write a C/C++ program which targets a remote PostgreSQL
database.
I don't know what to install, which libraries to link to in this program.

In more details:

Given:
1.1) a PostgreSQL database "db" on a machine A,
1.2) a machine B.

I would like to write a program (which is very classical) and run it on B:
2.1) connect to the remote PostgreSQL database "db" ;
2.2) "SELECT" one row in a table of this database ;
2.3) "UPDATE" this row.

B is a machine running a Debian Squeeze OS.
The program has to be written in C/C++.

Below are my questions:
- What libraries/PostgreSQL programming environment do I have to install on
B to be able to write this program?
- Does a whole PostgreSQL system have to be installed on B?
- Nota: I do not want to install a Debian package: I usually install
PostgreSQL from the sources.

This tutorial (PostgreSQL - C/C++ Interface - Using libpqxx library) looks
interesting:
http://www.tutorialspoint.com/postgresql/postgresql_c_cpp.htm
But after running "./configure" I get the following error:
----------------------------------------------------------------------------------
configure: error:
PostgreSQL configuration script pg_config not found. Make sure this is in
your
command path before configuring. Without it, the configure script has no
way to
find the right location for the libpq library and its headers.
----------------------------------------------------------------------------------
So, I'm wondering what are the prerequisites for this installation...

Nota: I would like to insist on the fact that there is no PostgreSQL related
material on B.

Best regards.

--
View this message in context: http://postgresql.nabble.com/Remote-PostgreSQL-database-C-C-program-Unix-Required-Libraries-tp5828704.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Léa Massiot 2014-11-30 19:51:50 Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries
Previous Message Damian Dimmich 2014-11-30 18:46:12 Re: i386 postgres on i686 debian with multiarch