libpqxx

How can I access the points of the polygon stored in Postgres using Libpqxx?

I want to retrieve the points of a polygon that are stored in the postgres db. The contents of the db are: polygonid |vertices -----------+--------------------------------------------------------------------- 2 |((1,0),(1.5,-1),(2,-1),(2,1),(1,1),(0,0),(0,2),(3,2),(3,-2),(1,-2)) 4 | ((3,3),(4,4),(5,5)) The vertices ...

Is there a way to list PostgreSQL servers?

Hi, Currently I am writing client to PostgreSQL servers. I want to list the details (ip address and port number) of the servers that is running PostgreSQL servers in the local network. Is there some methods in libpq or libpqxx ? Regards Devara Gudda ...

Can't link libpqxx in MinGW

Using MSYS, I compiled libpq (from compiling postgres). I then compiled libpqxx. Now, I want to create a client that will use libpqxx. libpq seemed to work fine. And, I can compile code with libpqxx. However, linking the libpq client application fails. Here's my code: #include <pqxx/pqxx> #include <iostream> using namespace std; ...

best practice for implementing a Search-Function via prepared statements.

I'm trying to implement a Search-Function using c++ and libpqxx. But I've got the following problem: The user is able to specify 4 different search patterns (each of them optional): from date till date document type document id Each of them is optional. So if I want to use prepared statements I would need 2^4 = 16 different prepared ...

Trouble with g++ & libpqxx lib

Hi2all, I've very simple example, and can't correctly build it, I was using next arguments: g++ -lpq -libpqxx -Wall -o "pg" "pg.cpp" (in dir: /home/user) /usr/lib/gcc/i586-suse-linux/4.5/../../../../i586-suse-linux/bin/ld: cannot find -lpq collect2: ld returned 1 exit status or returned 1 exit status g++ -libpqxx -Wall -o ...