Re: To pass schemaname as a function parameter - Mailing list pgsql-general

In response to Kalai R :
> 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
datatype). My code is like 
>
> CREATE FUNCTION disp_fn(schemaname text) AS $$
> BEGIN
>     SELECT * FROM schemaname.studentlist;
> END;
> $$ LANGUAGE plpgsql;

Not possible in this way, use EXECUTE:

   execute 'select * from ' || schemaname || '.studentlist';


(it is a dynamic SQL, you haven't a fix tablename)

Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)