Remote PostgreSQL database - C/C++ program / Unix / Required Libraries - Mailing list pgsql-general

From Léa Massiot
Subject Remote PostgreSQL database - C/C++ program / Unix / Required Libraries
Date
Msg-id 1417376681167-5828704.post@n5.nabble.com
Whole thread Raw
Responses Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries
Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries
List 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.


pgsql-general by date:

Previous
From: Damian Dimmich
Date:
Subject: Re: i386 postgres on i686 debian with multiarch
Next
From: Léa Massiot
Date:
Subject: Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries