9.2: Describing a security barrier view in psql

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

From: Dean Rasheed <dean.a.rasheed@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2012-09-03T09:17:26Z
Lists: pgsql-hackers

Attachments

Hi,

Unless I'm missing something, it is not possible in psql to tell
whether a view has the security_barrier option. I think that this is
something that ought to be possible from psql, otherwise the new
feature is not visible.

This patch displays any reloptions for a view at the end, if \d+ is
used, in the same way as for tables.

Sorry if this is too late for 9.2. I really only just noticed this,
despite playing with security barrier views for a while.

Regards,
Dean