You can't execute a SQL statement with a variable for a table name. However, you can create a string containing a SQL statement and then execute it. I don't know the postgres syntax.

This seems like one of those problems that might actually be in one of Joe Celko's books (but which one...)