SQL subquery to supply table name?

I have a situation where a table contains table names. I need to know if I
can make a Postgresql query that will have a subquery which supplies the
table name I want to deal with. Can this be done?

Something like this:
select column from (select table_name from table2 where key=value) where
key=value;

Scott