DROP FUNCTION typedoc_from_arch();
CREATE OR REPLACE FUNCTION typedoc_from_arch()
    RETURNS text AS
$BODY$
DECLARE
    row_t RECORD;
    t text = '';
    co INTEGER = 0;
    mas RECORD;
BEGIN

PERFORM dblink_disconnect('toarch'),dblink_connect('toarch','dbname=archive user=archive password=omumEot0');

/*
CREATE VIEW my_doctype AS
    SELECT * FROM dblink('toarch', 'SELECT id, ext_code, "name"  from document_type')
    AS t(id integer, ext_code character  varying(20), "name"  character varying(150));
*/


    FOR row_t IN SELECT *
        FROM dblink('toarch', 'SELECT  id,
      ext_code,
      "name"  from document_type')
        AS t_type_arch(id INTEGER, ext_code character  varying(20), "name"  character varying(150)) LOOP

    t := t || E'\r\n' || row_t.name;
    co := co +1;
    END LOOP;


RETURN t;

 --RETURN t;
END;
$BODY$
  LANGUAGE 'plpgsql' STABLE;