USER_LIBRARIES

Lists the user libraries that are currently loaded.

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
NAMESPACE_NAME VARCHAR For Eon Mode databases, name of the namespace that contains the library.
SCHEMA_NAME VARCHAR(8192)

The name of the schema containing the library.

If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, n1.s refers to schema s in namespace n1.

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.

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.