Hi. Suppose I have a database that contains a "meta table" that holds the names of other the tables in the database, keyed by human-readable but longish strings. I would like to write queries that first "compute" the names of some tables (i.e. by looking them up in "meta table"), and after that they execute subqueries using these computed table names. The following invalid SQL illustrates the kind of maneuver I'd like to do:
SELECT x, y, z
FROM [ SELECT table_name FROM meta_table
WHERE human_readable_key =
'some veeeery long and unwieldy string' ];
The stuff in [ brackets ] is not meant to be valid SQL, but rather to suggest that the name of the table for the "outer" query corresponds to the string returned by the "inner" (bracketed) query.
Some programming languages allow the run-time evaluation of a string representing some code in the language. One way to do what I'd like to do is based on this idea: I would construct the source code for the desired subquery as a string (including the name of the table obtained at run-time from meta_table), and "somehow" evaluate this string. This "somehow" is what I'm missing. Is there a way in PostgreSQL to evaluate a string as SQL?
TIA!
kynn
