#82: The pgquery type should have a method listtypes()
----------------------+-----------------
Reporter: cito | Owner:
Type: defect | Status: new
Priority: major | Milestone: 5.2
Component: DB API 2 | Version: 5.0
Keywords: |
----------------------+-----------------
As suggested on the mailing list 2019-06-07 by Justin Pryzby:
The query type of the `pg` module should have a method for exposing
`col_types` (the column types) of the query to Python. Currently you can
only get the number of results with `ntuples()` and the list of column
names with `listfields()`. Note that `col_types` only has the result of
`PQftype()`, it might be also interesing to get the type modifiers with
`PQfmod()`.
`pgdb` already provides this information in the `description` property via
the `listinfo()` method of the underlying source object which uses the
`_source_buildinfo` function.
Instead of adding a new method, we should probably add a property that
combines all of the information, like `description` in `pgdb`. Not sure if
an ordered dict (simple dict in Py >= 3.6) with names as keys or a list of
namedtuples like in `pgdb` would be better.
--
Ticket URL: <http://trac.pygresql.org:8000/pgtracker/ticket/82>
PyGreSQL <http://www.pygresql.org/>
PyGreSQL Tracker
_______________________________________________
PyGreSQL mailing list
PyGreSQL@Vex.Net
https://mail.vex.net/mailman/listinfo/pygresql
