<row>

<entry><literal>with_hierarchy</literal></entry>

<entry><type>yes_or_no</type></entry>

<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>

<entry>

In the SQL standard, <literal>WITH HIERARCHY OPTION</literal>

is a separate (sub-)privilege allowing certain operations on

table inheritance hierarchies. In PostgreSQL, this is included

in the <literal>SELECT</literal> privilege, so this column

shows <literal>YES</literal> if the privilege

is <literal>SELECT</literal>, else <literal>NO</literal>.

</entry>

</row>

</tbody>

</tgroup>

<row>

<entry><literal>with_hierarchy</literal></entry>

<entry><type>yes_or_no</type></entry>

<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>

<entry>

In the SQL standard, <literal>WITH HIERARCHY OPTION</literal>

is a separate (sub-)privilege allowing certain operations on

table inheritance hierarchies. In PostgreSQL, this is included

in the <literal>SELECT</literal> privilege, so this column

shows <literal>YES</literal> if the privilege

is <literal>SELECT</literal>, else <literal>NO</literal>.

</entry>

</row>

</tbody>

</tgroup>

pg_has_role(grantee.oid,c.relowner,'USAGE')

ORc.grantable

THEN'YES' ELSE'NO' ENDAS yes_or_no)AS is_grantable,

CAST('NO'AS yes_or_no)AS with_hierarchy

CAST(CASE WHENc.prtype='SELECT' THEN'YES' ELSE'NO' ENDAS yes_or_no)AS with_hierarchy

FROM (

SELECToid, relname, relnamespace, relkind, relowner, (aclexplode(relacl)).*FROM pg_class