SQL subquery to supply table name? - Mailing list pgsql-general

From Scott Chapman
Subject SQL subquery to supply table name?
Date
Msg-id 200209261604.14153.scott_list@mischko.com
Whole thread Raw
Responses Re: SQL subquery to supply table name?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: SQL subquery to supply table name?  (Scott Chapman <scott_list@mischko.com>)
Re: SQL subquery to supply table name?  (Scott Chapman <scott@mischko.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing
Next
From: Doug McNaught
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing