Extension:AccessPostgres

What can this extension do?
With this extension you can connect to a Postgres database and retrieve data with select directly into an article or write data into the database with insert and update respectively. You may also delete data from the database.

Usage
The following extension functions are available


 * #apGetValue: Retrieves a column from a table under specification of a search key. If the result consists of more than one value, the values are connected comma separated. The result is given as wikitext.


 * #apGetMValues: Retrieves any number of columns from a table under specification of a search key. The result is put into an array and returned as wikitext.


 * #apGetTable: Retrieves any number of columns and all rows from a table. The result is given as HTML table rows.


 * #apGetLine: Retrieves any number of columns from a table under specification of a search key. The result is given as HTML table row.


 * #apCreateEntry: Inserts a new record with any number of columns and a key column into a table. If there exists already a record with the given key value an update is performed instead.


 * #apUpdateMValues: Updates any number of columns under specification of a search key.


 * #apUpdatePValue: Updates a column under specification of two search keys.


 * #apAddValue: Inserts a new record with two columns (index and value) into a table.


 * #apDeletePEntry: Deletes a record from a table under specification of a key value and another search key.

All functions that perform a select use the user registered as $egOwlApUser. For insert and update the wiki user is used.

Download instructions
Download the code and unzip it into. Note: $IP stands for the root directory of your MediaWiki installation, the same directory that holds LocalSettings.php.

Installation
To install this extension, add the following to LocalSettings.php:

Configuration parameters
Insert the appropriate values for $egOwlApHost, $egOwlApDBName, $egOwlApUser, $egOwlApPassword and $egOwlApSearchPath in file
 * $egOwlApHost: name of the host on which Postgres is running
 * $egOwlApDBName: name of the postgres database to connect to
 * $egOwlApUser: user for select queries
 * $egOwlApPassword: password of $egOwlApUser
 * $egOwlApSearchPath: search path for the database