System Information Functions

Dolphin Session Information Functions

• database()

  Description: Name of the current database schema.

  Return type: name

  Example:

  MogDB=# SELECT database();
   database
  ----------
   public
  (1 row)

  Note: database returns the first valid schema name in the search path. (If the search path is empty or contains no valid schema name, NULL is returned.) This is the schema that will be used for any tables or other named objects that are created without specifying a target schema.

• uuid_short()

  Description: uuid_short information of the current database.

  Return type: int

  Example:

  MogDB=# select uuid_short();
      uuid_short    
  ------------------
  3939644819374082
  (1 row)

• dolphin_version()

  Description: Dolphin version information It returns a string describing the version information of the Dolphin plug-in.

  Return type: text

  Example:

  MogDB=# SELECT dolphin_version();
      dolphin_version
  ------------------------
   dolphin build 511401b6
  (1 row)

• dolphin_types()

  Description: Dolphin new type information. Returns a two-dimensional array of strings describing Dolphin's new type information, the information in each array is in order: type name, whether precision is supported, whether range is supported.

  Return type: text[][]

  Example:

  MogDB=# SELECT dolphin_types();
                      dolphin_types
  ----------------------------------------------------------------------------------------------------------------------------------------------
  {{uint1,false,false},{uint2,false,false},{uint4,false,false},{uint8,false,false},{year,true,false},{binary,true,false},{varbinary,true,false},{tinyblob,false,false},{mediumblob,false,false},{longblob,false,false},{set,false,false},{enum,false,false}}
  (1 row)