hi all,
I'm a newbie in postgresql. I've tried to make function but having
trouble in variable scooping.
here is the code in plpgsql:
"declare tbl_name varchar:='tbl_A';
begin
if exists(select 1 from pg_tables where tablename=tbl_name) then
select count(*) from tbl_name;
end if;
end"
the message was: syntax error in $1 in "select count(*) from $1". I
thought variable 'tbl_name' was not recognized. Why ?
Please need some help here.
Thx very much.