Use: <pre>SELECT <b>(</b>ctyp<b>)</b>.f1 FROM tbl;</pre> The parentheses are necessary to disambiguate tables from composite types as detailed in the [manual on composite types][1]. [1]: https://www.postgresql.org/docs/current/rowtypes.html#ROWTYPES-ACCESSING