Re: 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION - Mailing list pgsql-general

Dean Rasheed wrote on 19.05.2014 01:10:
>> when playing with 9.4 beta I noticed that the result of pg_get_viewdef()
>> will not include the new WITH CHECK OPTION clause when the view was created
>> using it.
>>
>> Is that intended (if so: why?) or is this an oversight/bug?
>>
>
> Yes, that's correct. pg_get_viewdef() only returns the underlying
> SELECT command for a view. This does not include any of the view's
> WITH parameters (check option and/or security barrier flag), because
> they aren't allowed in a SELECT statement.
>
> The additional parameters are held in pg_class.reloptions, and can be
> displayed from psql using \d+

Thanks, although not the answer I hoped for :)

I do think it would be a good thing to then have something like pg_get_full_viewdef (and a pg_get_full_tabledef() as
well)

Regards
Thomas