I work with a few C programmers (as part of a small software
development firm), but no one there is versed with Postgres databases.
 I?ll pay $20 if someone can introduce me to someone else who (a)
knows PostGres really well, (b) can program in C, (c)  can answer the
question:  ?How does one access and utilize variables from a Postgres
database from a dll written in C??, and (d) is willing to spend 10
minutes with my computer programmer on the phone answering this
question. I am willing to pay $20 to the PostGres expert who satisfies
(a)-(d).  In other words, $20 for the referral and $20 for the advice.

 

I need their name and phone number and I need to talk with them as
soon as possible (e.g., in the next couple of days).

---

Clarification of Question by sharpshooter2006-ga on 30 Nov 2006 06:26 PST

Some clarifying info from a member of our team:
- Our dll should be able to initialize some variables by reading the
information from the database. We have been able to accomplish this by
reading from a mysql database, but not from postgres.

- We are working on a windows xp environment and not on a linux
environment, what makes it difficult to find info on this issue.

- We want to link the libpq library with c, and we haven't been able to
do it yet.

This is the first time we are working with this database, so we are not
clear at all on the way the postgres libraries are linked with C.

I'm not sure what you mean "variables in a postgres database", but
unless postgresql has something special I've never heard of, what I
think you mean is that you just want to write programs/libraries in C
that can execute queries and updates with a postgres db. If so, this
is done in a standard way called ODBC:
http://www.easysoft.com/developer/interfaces/odbc/index.html

It is generic for any kind of relation database, provided the database
provides a odbc driver.

All the information you would need on how to use this can be found here:
http://www.easysoft.com/developer/languages/c/odbc_tutorial.html

the postgres odbc driver can be found here:
http://gborg.postgresql.org/project/psqlodbc/genpage.php?downloads


Now, it still might be better to have someone explain it outright, but
hopefully this can point you in the right direction.