1LOAD(7)                  PostgreSQL 15.4 Documentation                 LOAD(7)
2
3
4

NAME

6       LOAD - load a shared library file
7

SYNOPSIS

9       LOAD 'filename'
10

DESCRIPTION

12       This command loads a shared library file into the PostgreSQL server's
13       address space. If the file has been loaded already, the command does
14       nothing. Shared library files that contain C functions are
15       automatically loaded whenever one of their functions is called.
16       Therefore, an explicit LOAD is usually only needed to load a library
17       that modifies the server's behavior through “hooks” rather than
18       providing a set of functions.
19
20       The library file name is typically given as just a bare file name,
21       which is sought in the server's library search path (set by
22       dynamic_library_path). Alternatively it can be given as a full path
23       name. In either case the platform's standard shared library file name
24       extension may be omitted. See Section 38.10.1 for more information on
25       this topic.
26
27       Non-superusers can only apply LOAD to library files located in
28       $libdir/plugins/ — the specified filename must begin with exactly that
29       string. (It is the database administrator's responsibility to ensure
30       that only “safe” libraries are installed there.)
31

COMPATIBILITY

33       LOAD is a PostgreSQL extension.
34

SEE ALSO

36       CREATE FUNCTION (CREATE_FUNCTION(7))
37
38
39
40PostgreSQL 15.4                      2023                              LOAD(7)