How to return multi tables in postgres without refcursor?

Question

I have one procedure in sql server like:::

 

creare roc sp_fetch()

as

begin

select id,name from Tbl_User;

select projectId, projectname from Tbl_project

end; 

 

How to write the same query in postgres function without using refcursor? How to return multi result set from function?