CREATE VIEW sgm_flow.activiti_proceso AS

Select * from  dblink(
'dbname=activiti host=127.0.0.1 user=sisapp password=sisapp98',
'SELECT id_, proc_def_id_, task_def_key_, proc_inst_id_, execution_id_,
       name_, parent_task_id_, description_, owner_, assignee_, start_time_,
       claim_time_, end_time_, duration_, delete_reason_, priority_,
       due_date_, form_key_, category_, tenant_id_
  FROM public.act_hi_taskinst')
as (
  id_ character varying(64),
  proc_def_id_ character varying(64),
  task_def_key_ character varying(255),
  proc_inst_id_ character varying(64),
  execution_id_ character varying(64),
  name_ character varying(255),
  parent_task_id_ character varying(64),
  description_ character varying(4000),
  owner_ character varying(255),
  assignee_ character varying(255),
  start_time_ timestamp without time zone ,
  claim_time_ timestamp without time zone,
  end_time_ timestamp without time zone,
  duration_ bigint,
  delete_reason_ character varying(4000),
  priority_ integer,
  due_date_ timestamp without time zone,
  form_key_ character varying(255),
  category_ character varying(255),
  tenant_id_ character varying(255) );


SELECT * FROM sgm_flow.activiti_proceso