The Adodb database abstraction library is free to use and works very
well. I like it even in projects that will only use postgres. It makes
programming databases easier, will do a lot of the mundane work for you,
and if you have different projects that use different databases, it
allows you to use the same adodb commands.
You can find all kinds of information about adodb including a function
reference, tutorials and download links at
http://php.weblogs.com/adodb_manual
Keep in mind that this library was originally modeled after Microsofts
Ado library. Therefore, it does not bear a strong resemblance to the
native php db functions. An interesting side effect though is that I
recently had to write a simple Visual Basic application and found that I
already knew most of the database stuff because of my php adodb
experience. :-)
Matthew Nuzum
www.followers.net
matt@followers.net
-----Original Message-----
From: Boget, Chris [mailto:chris@wild.net]
Sent: Monday, December 30, 2002 5:14 AM
To: 'php-general@lists.php.net'
Cc: 'pgsql-general@postgresql.org'
Subject: PHP & PostgreSQL
I'm switching from a MySQL environment to PGSQL and I'm
going through and trying to learn the differences between the
two. I've come across some issues that I can't seem to find the
answers to in the docs or on the web. I'm hoping someone can
help me out.
* MySQL has a function to reset the result set so that it can be
iterated through again - mysql_data_seek(). I don't see that there
is a similar function for PGSQL. Is that true? If so, in order to
reset the result set you have to perform the query again? Isn't
that a waste of resources?
* For PGSQL, you can get the database name, the field name
even the *host name* but you can't get the table name from a
particular query?
Any info would be greatly appreciated!
Chris