Hi,
I wrote a function in plpgsql, to dispaly the student list.
In a Database all schemas contains studentlist table. so I wrote the
function with schemaname as a parameter(text data type). My code is
like
CREATE FUNCTION disp_fn(schemaname text) AS $$
BEGIN
SELECT * FROM schemaname.studentlist;
END;
$$ LANGUAGE plpgsql;
In the above function schemaname varaible does not taken.
Is there any way to pass schemaname as argument? Any idea would be
much appreciated.
Thanks in Advance.
Regards
Softlinne