Since PxPlus does not provide a direct interface to PostgreSQL, you need to download
and install the ODBC driver
The attached code connects to a database on the local machine using a DSN-less connection string
When run, it yields :
You can also insert to a table (very simple schema : an auto-increment id and a varchar description :
1:write record (pgdb)"insert into categories (category_name) values ('Friends')"
1:write record (pgdb)"select * from categories where category_id=3"
And update as well :
1:write record (pgdb)"update categories set category_name='Professional' where c
1:write record (pgdb)"select * from categories where category_id=2"