1LOAD(7) PostgreSQL 14.3 Documentation LOAD(7)
2
3
4
6 LOAD - load a shared library file
7
9 LOAD 'filename'
10
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
33 LOAD is a PostgreSQL extension.
34
36 CREATE FUNCTION (CREATE_FUNCTION(7))
37
38
39
40PostgreSQL 14.3 2022 LOAD(7)