add to table which name is in table

From: teknet(at)poczta(dot)onet(dot)pl
To: pgsql-admin(at)postgresql(dot)org
Subject: add to table which name is in table
Date: 2004-07-17 07:41:58
Message-ID: 20040717074205Z135895-30879+518592@kps2.test.onet.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2004-07-17 08:39:41 Re: add to table which name is in table
Previous Message mike g 2004-07-17 04:38:52 Re: inheritance question