title: Metadata of a struct type column in Postgres
body: <p>In my Postgres database i have this table:</p>
  
  <pre><code>CREATE TYPE address_type AS (
       name    text,
       street  text,
       houseno integer );
  
  CREATE TABLE person (
       address   address_type,
       count     integer ); 
  </code></pre>
  
  <p>I need to fetch meta data of the fields for address_type. <br>
  I have been through the <a href="https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html" rel="nofollow noreferrer">documentation</a> and <a href="https://stackoverflow.com/questions/696782/retrieve-column-names-from-java-sql-resultset">this</a> and it's likes but getting just the column name and it's datatype is not enough for me, i need to get the meta data for the fields of the column as well, like, what all fields the struct has (name, street, houseno) and what are their types (text, text, int). <br>
  Can someone please guide me in this regard?
  Is it even feasible at all?</p>