[danciu]

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

Expand|Select|Wrap|Line Numbers

1.     if .... then
2.       mytablename='John';
3.     else
4.       mytablename='Johnson';
5.    end if;
6.  
7.  
8.     create temp table mytablename as.........;

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

[rski]

you can try create table using dynamic sql

Expand|Select|Wrap|Line Numbers

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

[danciu]

It really works, thanks.