INSERT INTO t1(id, name, description, "date")
    SELECT id_foo, full_name, des, "date" FROM
    dblink('host= ? user= ? password= ? dbname= externaldb'::text,
    'SELECT id, name, description, "date" FROM t2'::text, false)
    ttemp(id integer, name character varying,  description character varying, "date" date)
)