Its possible apply COPY TYPE in CREATE TYPE name_type?

30 Views Asked by At

postgres 15 show error apply in this manner error email users.email%TYPE

CREATE TYPE userx AS (
        email users.email%type, 
        name user.name%type, 
        area users.profession%type);

in tried replicated for oracle syntax

Type  tipo_r  IS RECORD (id  number(3),
                   nombre  varchar(10),
                   salario  emp.salary%type); 
0

There are 0 best solutions below