'Is there any use for the pg_type type?

Is there any real world use for the type pg_type, i.e type ids 71 and 210. Although it's a bit of a faff, queries can result in this type output, as in the below where an explicit cast to pg_type is used.

SELECT (
    1,'The "name",',1,1,1,TRUE,'a','a',TRUE,TRUE,'a',1,1,1,
    1,1,1,1,1,1,1,1,'a','a',TRUE,1,1,1,1,
    (SELECT typdefaultbin FROM pg_type WHERE typname = 'time_stamp' LIMIT 1),
    1,'{{postgres=a}}'
)::pg_type

Context: I'm writing a Python PostgreSQL adapter, and want to know if it's worth writing/hooking up a parser for this type.

pythonpostgresqllibpq


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions