Object (Table, View ...) Status Metadata in Postgres

Question

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

https://stackoverflow.com/a/39120069/5315974 – Vao Tsun Jul 10 '17 at 14:49 — Vao Tsun, Jul 10 '17 at 14:49

score 0 · Answer 1 · answered Jul 10 '17 at 14:52

https://stackoverflow.com/a/39120069/5315974

Postgres does not let you break the view (RULE), eg:

t=# create table so183 (i int);
CREATE TABLE
t=# create view v183 as select i from so183;
CREATE VIEW
t=# alter table so183 alter COLUMN i type text using i::text;
ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view v183 depends on column "i"

Object (Table, View ...) Status Metadata in Postgres

1 Answers1