Dean Rasheed <dean.a.rasheed@xxxxxxxxx> writes: > On 17 May 2014 13:25, Thomas Kellerer <spam_eater@xxxxxxx> wrote: >> 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. > 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+ I have to concur with the OP that this seems like a pretty darn weird design choice. reloptions are for nonstandard PG-specific options, not for SQL-spec-mandated syntax. What was the rationale for doing it like that? regards, tom lane
