SET

Description

This command allows altering the configuration of the current session.

Variations

SET MODULE module

Set the default module for the current section to module.

For example, if a module foo contains type FooType, the following is how the type can be referred to:

Copy

# Use the fully-qualified name.
SELECT foo::FooType;

# Use the WITH clause to define the default module
# for the query.
WITH MODULE foo SELECT foo::FooType;

# Set the default module for the current session ...
SET MODULE foo;
# ... and use an unqualified name.
SELECT FooType;

SET ALIAS alias AS MODULE module

Define alias for the module.

For example:

Copy

# Use the fully-qualified name.
SELECT foo::FooType;

# Use the WITH clause to define a custom alias
# for the "foo" module.
WITH bar AS MODULE foo
SELECT bar::FooType;

# Define "bar" as an alias for the "foo" module for
# the current session ...
SET ALIAS bar AS MODULE foo;
# ... and use "bar" instead of "foo".
SELECT bar::FooType;

Examples

SET MODULE foo;

SET ALIAS foo AS MODULE std;

See Also

RESET ALIAS command.