CREATE OR REPLACE FUNCTION extractstudent()
    RETURNS VOID AS 
    $BODY$
    DECLARE
    	studcur SCROLL cursor FOR SELECT fname, lname, mname, address FROM student;
    BEGIN    
    	open studcur; 
    	
    	Loop
    	--fetching 1 row at a time
    	FETCH First FROM studcur;
    	--every row fetched is being inserted to another database on the local site
    	--myconT is the name of the connection to the other database in the local site
    	execute 'SELECT * from dblink_exec(''myconT'', ''insert into temp_student values(studcur)'')';
    	--move to the next row and execute again
    	move next from studcur;
    	--exit when the row content is already empty
    	exit when studcur is null;
    	end loop;
    
    	close studcur;    
    	
    END;
    $BODY$
      LANGUAGE plpgsql VOLATILE
      COST 100;
    ALTER FUNCTION extractstudent() OWNER TO postgres;