SET
– set one or multiple session-level parameters
SET MODULE module ;
SET ALIAS alias AS 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:
# 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;
Define alias for the module.
For example:
# 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;
RESET ALIAS command.