add to table which name is in table - Mailing list pgsql-admin

Hello

i have table:

create table table_names (
id                      SERIAL,
name                VARCHAR(75) NOT NULL
);

and for each name in table_names i have table (which name is name field from table_names).

So in table_names i have records:

1 table1

2 table2

3 table3

So i have three other tables named: table1 table2 table3.

And i want to operate on that tables by reading their names from table_names. I tried:

select * from (select name from table_names where id=1) as something;

but i received only:

 table_names
--------------
 table1
(1 row)

And i wanted to receive everything from table1.

How can i do it ?

Thanx

Michal