CREATE OR REPLACE FUNCTION show (text, text)
 RETURNS setof record AS $$
 select table_name,column_name,data_type from information_schema.columns 
 where table_name like $1 || '%' and column_name like $2 || '%';
 $$ LANGUAGE sql;



/* actual output
*
* test=# select show('ord','car');
* 
*                 show
*--------------------------------------
* (orders,carrier,"character varying")
*(1 row)
*
*
*
* desired output
*
* test=# select table_name,column_name,data_type from information_schema.columns where table_name like '%ord%' and column_name like '%car%';
*
*
* table_name | column_name |     data_type
*------------+-------------+-------------------
* orders     | carrier     | character varying
*(1 row)
*
*/