create table MyVariable

danciu

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

Expand|Select|Wrap|Line Numbers

     if .... then

      mytablename='John';

    else

      mytablename='Johnson';

   end if;
 
    create temp table mytablename as.........;

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

rski

you can try create table using dynamic sql

Expand|Select|Wrap|Line Numbers

danciu

It really works, thanks.

re: create table MyVariable