PGSQL_Record2
Start pgAdmin application, by clicking on  pgAdmin3.exe

Open a new SQL pane

 

CREATE OR REPLACE FUNCTION get_record_row1(i int)
RETURNS emp AS $$
DECLARE
rec RECORD;
BEGIN
EXECUTE 'SELECT * from emp where empno =' || i INTO rec;
RETURN rec;
END;
$$ LANGUAGE plpgsql;

Save as : get_record_row1

pgAdmin registers the function

select * from get_record_row1(7521);

Using command prompt: Click on the ICON/Menu as shown below to open a consolewindow

Using PHP - PostgreSQL Query Tool