title: CREATE TYPE "XYZ" AS TABLE OF VARCHAR2(104) in postgresql
body: <p>I have converted the types from oracle to postgres using the </p>
  
  <blockquote>
    <p>ORa2pg</p>
  </blockquote>
  
  <p>tool</p>
  
  <pre><code>CREATE  TYPE "XYZ" AS TABLE OF VARCHAR2(104) 
  </code></pre>
  
  <p>The same is working fine in oracle . but the ora2pg converts the same as it is in postgres
  with the warning as 
  -- Unsupported, please edit to match PostgreSQL syntax</p>
  
  <pre><code>CREATE  TYPE "XYZ" AS TABLE OF VARCHAR(104)
  </code></pre>
  
  <p>Not Working in the postgres</p>
  
  <p>I have tried the other queries as</p>
  
  <pre><code>create type XYZ as (xyz varchar[])
  </code></pre>
  
  <p>But the same is not usefull as it is not giving the desired result The Type does not match </p>
  
  <p>Function is receiving the type Table of varchar but the  </p>
  
  <pre><code>create type XYZ as (xyz varchar[])
  </code></pre>
  
  <p>is of composite type in postgres</p>
  
  <p>Is there any way to have a type which is same as the above .. Pls Help</p>