Re: [GENERAL] To pass schemaname as a function parameter

On Thu, Sep 3, 2009 at 7:37 AM, A. Kretschmer wrote: > 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 data type). My code is

Re: [GENERAL] To pass schemaname as a function parameter

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 data type). My code is like > > CREATE FUNCTION disp_fn(schemaname text) AS $$ >

[GENERAL] To pass schemaname as a function parameter

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.studentl