Hi, my name is Emil, I am a software engineer at NEC, Japan.  This is not in
any way related to my work, but I am that interested in cygwin that I
installed it on my own PC and right now I am enjoying it.  Your work is a
good one really, I appreciate what you guys are doing.

I am just wondering, because I have installed PostgreSQL on my Cygwin
(Windows NT) and this is my first time to attempt a dive into the database
realm. I am not sure of this, but there should be a way to access a database
through say, a C++ program.  Right now my Cygwin-PostgreSQL database is
working fine, I was able to create databases and tables, view them, modify
the contents, etc.  But what I really want to do right now is to create a
simple program that would successfully connect to my PostgreSQL databases (i
have to specify the database i assume).  Just a 5-liner maybe, just to test
the connection.

I tried and looked for some sample codes in the internet but I cant quite
find a good one.  I hope you guys can help me.

My PostgreSQL is running okay, i just dont know what functions should be
called, what header files to include, etc.

Thank you for your time guys, and i hope to hear from you soon.

PS
  Maybe in the future, when I get to know a lot about Cygwin, I would
contact you guys and join your support group probably... :-)


Sincerely,
Emilio Uy III


＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠
　　　　　　　　　　Emilio Uy III
　　　　　　　　エミリオ　ウイ　III　　　　

　　　　　ＮＥＣ通信システム九州（株）
　＜メイル＞　　emilio@qncos.nec.co.jp　
　　　　　　　　　 e.uy@pgs.com.ph
　　　　　　　　　 emil_uy_iii@docomo.ne.jp
　＜携帯電話＞　090-24510266　
　＜家電話＞　　 092-8839411
＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠





Wed, 26 Jun 2002 12:22:54 +0900
"Emilio Uy III" <emilio@qncos.nec.co.jp>
database access via c++ program...
On Wed, Jun 26, 2002 at 12:22:54PM +0900, Emilio Uy III wrote:
> 
> I am just wondering, because I have installed PostgreSQL on my Cygwin
> (Windows NT) and this is my first time to attempt a dive into the database
> realm. I am not sure of this, but there should be a way to access a database
> through say, a C++ program.  Right now my Cygwin-PostgreSQL database is
> working fine, I was able to create databases and tables, view them, modify
> the contents, etc.  But what I really want to do right now is to create a
> simple program that would successfully connect to my PostgreSQL databases (i
> have to specify the database i assume).  Just a 5-liner maybe, just to test
> the connection.
 
If you're using gcc or a similarly good compiler (Visual C++ will NOT work),
try libpqxx:

	http://members.ams.chello.nl/j.vermeulen31/proj-libpqxx.html

I don't know how well it installs under Cygwin, but a simple test program
using libpqxx as its C++ interface to PostgreSQL can be something like:


	#include <iostream>

	#include <pqxx/connection.h>
	#include <pqxx/transaction.h>
	#include <pqxx/result.h>

	using namespace std;
	using namespace pqxx;

	int main()
	{
		try
		{
			Connection C("dbname=mydatabase");
			Transaction T(C, "T");
			Result R = T.Exec("SELECT * FROM pg_tables");

			for (Result::const_iterator c = R.begin();
				c != R.end();
				++c)
			{
				cout << c[0].c_str() << endl;
			}

			T.Commit();
		}
		catch (const exception &e)
		{
			cerr << e.what() << endl;
			return 1;
		}

		return 0;
	}

HTH,

Jeroen




Wed, 26 Jun 2002 16:42:26 +0200
jtv <jtv@xs4all.nl>
Re: database access via c++ program...