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

postgreSQL.cursor.executeMultipleQueries

postgreSQL.cursor.callProcedure