title: How to get entire table data or multiple rows returned from a function in PG/PLSQL with pgAdmin 4.2.?
body: <p><strong>I tried using setof and table.</strong> While creating function in <strong>pgAdmin 4.2</strong> there is no return type called setof or table. If I create function with setof and table name as a selected return type, it only returns one row of table.</p>
  
  <pre><code>CREATE FUNCTION pgsql_returnrecords() RETURNS SETOF RECORD(name char, city, char, id integer) AS 
  $BODY$
  DECLARE
   rec RECORD;
  BEGIN
  select name,city,id INTO rec from test;
  return next rec;
  END;
  $BODY$ language plpgsql;
  </code></pre>
  
  <p>I want my function to return table data with all rows and columns.</p>