david, you're right. i didn't realize it had to be executed inside a function so now i'm trying this:
-- create function create or replace function get_tables(sname varchar) returns record as $$ select tablename from pg_tables where schemaname = $1; $$ language 'plpgsql'; -- query tables where column 'fname' = 'john' select * from get_tables('myschema') where fname = 'john'; any help? wishing for a "select * from *..." :) thanks, jzs