GUC Value Inquiry Functions

• show(text)

  Description: returns the current setting of this GUC variable.

  Return value type: SETOF RECORD

  Example:

  MogDB=# select SHOW('enable_custom_parser');
                          show                        
  ----------------------------------------------------
   name                 | set | description
   ---------------------+-----+----------------------
   enable_custom_parser | off | Enables custom parser
  (3 rows)

• show_parameter(text)

  Description: Returns the value currently set for this GUC variable.

  Return value type: SETOF RECORD

  Example:

  MogDB=# select show_parameter('enable_default');
                                            show_parameter                              
               
  --------------------------------------------------------------------------------------
   name                             | set | description
   ---------------------------------+-----+---------------------------------------------
   enable_default_cfunc_libpath     | on  | Enable check for c function lib path.
   enable_default_compression_table | off | Enables create table default compression tab
  le or not.
   enable_default_ustore_table      | off | Creates all user-defined tables with orienta
  tion inplace
  (5 rows)