title: How to create User defined Datatype with %TYPE and %ROWTYPE in PGAdmin 4
body: <p>Being new to PostgreSQL &amp; PGAdmin 4, I am not being able to create a <code>TYPE</code> with data type containing <code>%TYPE</code> to any other table's column(referenced item). PGAdmin 4 GUI is only giving option to use any primitive datatypes.</p>
  
  <h2>What PgAdmin is allowing:</h2>
  
  <pre><code>CREATE TYPE logindetails AS
  (
      accesscode smallint,
      displayname character varying(50)
  );
  </code></pre>
  
  <h2>What I need:</h2>
  
  <pre><code>CREATE TYPE logindetails AS
  (
      accesscode moduleaccess.access_level%type,
      displayname usermaster.user_name%type);
  </code></pre>
  
  <p>Any help is much appreciated.</p>
  
  <p>Regards,
  Abhirup.</p>