Is it possible to query object (object being table, view, etc.) status in Postgres? In Oracle an equivalent query would be:
SELECT owner,
object_name,
status
FROM all_objects
WHERE object_type = 'VIEW'
(returns VALID/INVALID in status column)
Please let me know. I've googled for this already, but have not found much.
Michael