pg_select submits a query (SELECT statement) to the PostgreSQL server and executes a given chunk of code for each row in the result. The commandString must be a SELECT statement; anything else returns an error. The arrayVar variable is an array name used in the loop. For each row, arrayVar is filled in with the row values, using the column names as the array indices. Then the procedure is executed.
In addition to the column values, the following special entries are made in the array:
.headers
A list of the column names returned by the query.
.numcols
The number of columns returned by the query.
.tupno
The current row number, starting at zero and incrementing for each iteration of the loop body.
Arguments
conn
The handle of the connection on which to execute the query.
commandString
The SQL query to execute.
arrayVar
An array variable for returned rows.
procedure
The procedure to run for each returned row.
Return Value
None
Examples
This examples assumes that the table table1 has columns control and name (and perhaps others):
Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
Free Sample Chapters