postgreSQL.cursor.getDescription
Syntax
postgreSQL.cursor.getDescription (cursorRef)
Params
cursorRef is a reference to a cursor as returned by postgreSQL.cursor.create.
Action
Get a description of the columns in the result set generated by the last query or procedure call.
Returns
A list containing one record for every column in the result set.
Examples
postgreSQL.cursor.getDescription (cursorRef)
« {{"name":"sqrt", "pgsize":8, "pgtype":701, "odbtype":'exte'}}
Notes
Each record of the returned list currently contains four items:
name is a string specifying the name of the column.
pgsize is a number specifying the number of bytes used by the backend to store the column's data type in the database.
pgtype is a number specifying the data type of the column as listed in the pg_type system catalog.
odbtype is a string4 specifying the UserTalk type that values from the column will be converted to when they are fetched.
If the last query or procedure call did not generate a result set, this verb returns an empty list.
See Also
postgreSQL.cursor.executeQuery