i have table:
create table table_names (
name VARCHAR(75) NOT NULL
and for each name in table_names i have table (which name is name field from
So in table_names i have records:
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:
And i wanted to receive everything from table1.
How can i do it ?
pgsql-admin by date
|Next:||From: Oliver Elphick||Date: 2004-07-17 08:39:41|
|Subject: Re: add to table which name is in table|
|Previous:||From: mike g||Date: 2004-07-17 04:38:52|
|Subject: Re: inheritance question|