Functions / System Information Functions And Operators
Does user have privilege for any column of table? This succeeds either if the privilege is held for the whole table, or if there is a column-level grant of the privilege for at least one column.
Reading PG 18current·documented in 19 of 27 versions, 8.4 to 20
has_any_column_privilege ( [ user name or oid, ] table text or oid, privilege text ) → booleanDoes user have privilege for any column of table? This succeeds either if the privilege is held for the whole table, or if there is a column-level grant of the privilege for at least one column. Allowable privilege types are
SELECT, INSERT, UPDATE, and REFERENCES.Definition snapshot: b7bd9cda · English manual source