Start pgAdmin application

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