USER_LIBRARIES

Lists the user libraries that are currently loaded. These libraries contain user-defined extensions (UDxs) that provide additional analytic functions.

Column Name Data Type Description
SCHEMA_NAME

VARCHAR(8192)

The name of the schema containing the library.

LIB_NAME

VARCHAR(8192)

The name of the library.

LIB_OID

INTEGER

The object ID of the library.

AUTHOR
VARCHAR(8192) The creator of the library file.
OWNER_ID

INTEGER

The object ID of the library's owner.

LIB_FILE_NAME

VARCHAR(8192)

The name of the shared library file.

MD5_SUM

VARCHAR(8192)

The MD5 checksum of the library file, used to verify that the file was correctly copied to each node.

Note: This use of MD5 is not for cryptographic or authentication purposes. For information on authenticating with MD5 see Hash Authentication.

SDK_VERSION

VARCHAR(8192)

The version of the Vertica SDK used to compile the library.

REVISION

VARCHAR(8192)

The revision of the Vertica SDK used to compile the library.

LIB_BUILD_TAG
VARCHAR(8192) Internal information set by library developer to track the when the library was compiled.
LIB_VERSION
VARCHAR(8192) The version of the library.
LIB_SDK_VERSION
VARCHAR(8192) The version of the Vertica SDK intended for use with the library. The developer sets this value manually. This value may differ from the values in the SDK_VERSION and REVISION, which are set automatically during compilation.
SOURCE_URL
VARCHAR(8192) A URL that contains information about the library.
DESCRIPTION
VARCHAR(8192) A description of the library.
LICENSES_REQUIRED
VARCHAR(8192) The licenses required to use the library.
SIGNATURE
VARCHAR(8192) The signature used to sign the library for validation.
DEPENDENCIES
VARCHAR (8192) External libraries on which this library depends. These libraries are maintained by Vertica, just like the user libraries themselves.