Return dynamically created table from function

[vinayansr]

Hello,

I have created one function which create dynamically pivot table .Now I want to return that table from function. Generally we return table with fixed number of columns with data type, But now I don know no of columns.Table will create dynamically and want to return that table. What should I do?
Please suggest.

[vinayansr]

Hello,
I am working on postgresql database. Please help for solution.

[vinayansr]

Here is function

CREATE OR REPLACE FUNCTION get_records()
  RETURNS setof text AS
$BODY$
DECLARE
query TEXT;
table_name character varying;
result text;
BEGIN
create temp table testing(a integer,b integer);
insert into testing values(1,2);
insert into testing values(3,4);
table_name = 'testing';
create table test as select * from testing;
Perform (get_records_test('test')::test).* ;
drop table testing;
drop table test123;
END;
$BODY$
 
 
 
 
CREATE OR REPLACE FUNCTION get_records_test(table_name text)
  RETURNS SETOF text AS
$BODY$
DECLARE
query TEXT;
BEGIN
query = format('SELECT  %s::text FROM %s', table_name, table_name);
raise notice 'Query(%)',query;
RETURN QUERY EXECUTE query;
END;
$BODY$