record_inspect defines functions which allow introspection of record and composite types from PL/pgSQL and PL/SQL. record_inspect defines the following database objects, all in the schema record_inspect.

• fieldinfo [composite type] Used to by fieldinfos() to describe a record's fields. Contains the fields fieldname (name), fieldtype (regclass), fieldtypemod (varchar)

• fieldinfo[] fieldinfos(record) Returns an array of s describing the record''s fields

• anyelement fieldvalue(record, field name, defval anyelement, coerce boolean) Returns the value of the field , or should the value be null. If is true, the value is coerced to 's type if possible, otherwise an error is raised if the field''s type and 's type differ.

• anyelement fieldvalues(record, defval anyelement, coerce boolean) Returns an array containing values of the record'' fields. NULL values are replaced by . If is false, only the fields with the same type as are considered. Otherwise, the field'' values are coerced if possible, or an error is raised if not.

Installation:

Do make install or make PG_CONFIG=/path/to/your/pg_config install This will install record_inspect.so into /lib (or