Discussion:
Connecting to PostgreSQL simple SQL statements
(too old to reply)
Nick Peterson
2007-11-20 22:10:36 UTC
Permalink
Hello Everyone,

I'm *very* knew to Delphi (started a day ago) and I need to connect to a postgresql server and execute some simple SQL commands. These commands include SELECT, UPDATE and INSERT. The most that will be returned is a couple hundred rows which are 32 bytes max each. I'm building this in Delphi 6 and I'm not sure how I can do this. Any ideas, I'm hopelessly lost.

-Nick
jkuiper
2007-11-21 10:27:06 UTC
Permalink
Witch driver on connecting the progress database you using?

John
Post by Nick Peterson
Hello Everyone,
I'm *very* knew to Delphi (started a day ago) and I need to connect to a postgresql server and execute some simple SQL commands. These commands include SELECT, UPDATE and INSERT. The most that will be returned is a couple hundred rows which are 32 bytes max each. I'm building this in Delphi 6 and I'm not sure how I can do this. Any ideas, I'm hopelessly lost.
-Nick
der_mensch
2007-11-27 04:51:59 UTC
Permalink
Post by Nick Peterson
Hello Everyone,
I'm *very* knew to Delphi (started a day ago) and I need to connect to a postgresql server and execute some simple SQL commands. These commands include SELECT, UPDATE and INSERT. The most that will be returned is a couple hundred rows which are 32 bytes max each. I'm building this in Delphi 6 and I'm not sure how I can do this. Any ideas, I'm hopelessly lost.
-Nick
You need a driver:

DBExpress, does not work for me with DBX4 (Delphi 2007) (limited trial):
---------
http://www.vitavoom.com/Products/pgExpress_Driver/index.html
The pgExpress Driver


dbexpress odbc (free):
--------------
http://open-dbexpress.cvs.sourceforge.net/open-dbexpress/dbxoodbc/
along with:
http://pgfoundry.org/projects/psqlodbc/


TDataSet (not dbexpress) (unlimited trial with nag screen):
--------
http://www.microolap.com/products/connectivity/postgresdac/
PostgresDAC - Direct Access Components for PostgreSQL and Pervasive Postgres


TDataSet (not dbexpress) (free):
--------
http://zeos.firmos.at/
zeos


There is also a free library for direct access to the postgresql client.
I can't remember the name.


dave m
Bill Todd
2007-11-27 20:43:07 UTC
Permalink
One way to connect to PostgreSQL is to use the ODBC driver and the
Delphi ADO components.
--
Bill Todd (TeamB)
Cedric Pemberton
2007-12-19 21:18:31 UTC
Permalink
Hi there nick you might try looking at the ZeosLib components they
support Postgres. They can be found on Source Forge.
Post by Nick Peterson
Hello Everyone,
I'm *very* knew to Delphi (started a day ago) and I need to connect to a postgresql server and execute some simple SQL commands. These commands include SELECT, UPDATE and INSERT. The most that will be returned is a couple hundred rows which are 32 bytes max each. I'm building this in Delphi 6 and I'm not sure how I can do this. Any ideas, I'm hopelessly lost.
-Nick
Loading...