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
