1LOAD(7) PostgreSQL 9.2.24 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 file name is specified in the same way as for shared library names
21 in CREATE FUNCTION (CREATE_FUNCTION(7)); in particular, one can rely on
22 a search path and automatic addition of the system's standard shared
23 library file name extension. See Section 35.9, “C-Language Functions”,
24 in the documentation for more information on this topic.
25
26 Non-superusers can only apply LOAD to library files located in
27 $libdir/plugins/ — the specified filename must begin with exactly that
28 string. (It is the database administrator's responsibility to ensure
29 that only “safe” libraries are installed there.)
30
32 LOAD is a PostgreSQL extension.
33
35 CREATE FUNCTION (CREATE_FUNCTION(7))
36
37
38
39PostgreSQL 9.2.24 2017-11-06 LOAD(7)