Horton

psql: Add leakproof indicator to \df+, \do+, \dAo+, and \dC+ output.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 2355e51110e7c687c125a5958f12a462931de996
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2025-01-14T13:23:24Z
Releases: 18.0 
psql: Add leakproof indicator to \df+, \do+, \dAo+, and \dC+ output.

This allows users to determine whether particular functions are
leakproof, and whether the underlying functions used by operators and
casts are leakproof. This is useful to determine whether indexes can
be used in queries on security barrier views or tables with row-level
security policies.

Yugo Nagata, reviewed by Erik Wienhold and Dean Rasheed.

Discussion: https://postgr.es/m/20240701220817.483f9b645b95611f8b1f65da%40sranhm.sraoss.co.jp

Files

PathChange+/−
doc/src/sgml/planstats.sgml modified +3 −0
doc/src/sgml/ref/psql-ref.sgml modified +10 −8
doc/src/sgml/rules.sgml modified +11 −0
src/bin/psql/describe.c modified +42 −12
src/test/regress/expected/psql.out modified +40 −35
src/test/regress/sql/psql.sql modified +1 −1

Documentation touched

Discussion