create table MyVariable

[danciu]

Can I write in a plpgsql function a code like this:
declare mytablename char(10);
............... ...........

    if .... then
      mytablename='John';
    else
      mytablename='Johnson';
   end if;


    create temp table mytablename as.........;

............... ..??

[rski]

you can try create table using dynamic sql

execute 'create temp table '||table_name ....

[danciu]

It really works, thanks.