Postgres - Passing table name as parameter and store result in file

Question

    Create Or Replace Function totalRecords (tablename TEXT) Returns integer as $total$
    Declare
      total integer;

      Begin
       select count  (*)  into  total  from''|| tablename ||' 'where now() - cast(date_dimension_year||'-'||date_dimension_month||'-'||date_dimension_day AS date) < INTERVAL '3 months' ;
        RETURN total;
       END;
$total$ LANGUAGE plpgsql;

i have a task which is to create a function which checks the DB for records on given condition if satisfied should output the result to a text file.The above pasted code is what i have been playing around with no sucess.I get syntax error....could anyone guide me on this? I am using postgres DB.

possible duplicate of [Table name as a PostgreSQL function parameter](http://stackoverflow.com/questions/10705616/table-name-as-a-postgresql-function-parameter) — , Apr 29 '14 at 08:49

score 0 · Answer 1 · answered May 07 '14 at 12:12

I sorted the issue this way

 Begin
 execute 'select count(*) from ' ||tablename||
' where cast(date_dimension_year || ''-'' || date_dimension_month || ''-''||date_dimension_day as date) 
not between (current_date - interval ''13 months'') and current_date' into total ;

I had to assign the integer total towards the end and proper closing of quotation (') worked for me.( I just pasted a portion of the function where i was getting issue)

Thanks for all your help.

Postgres - Passing table name as parameter and store result in file

1 Answers1