1LOAD(7)                          SQL Commands                          LOAD(7)
2
3
4

NAME

6       LOAD - load a shared library file
7
8

SYNOPSIS

10       LOAD 'filename'
11
12

DESCRIPTION

14       This  command  loads a shared library file into the PostgreSQL server's
15       address space. If the file has been loaded already,  the  command  does
16       nothing.  Shared  library  files that contain C functions are automati‐
17       cally loaded whenever one of their functions is called.  Therefore,  an
18       explicit  LOAD  is  usually only needed to load a library that modifies
19       the server's behavior through ``hooks'' rather than providing a set  of
20       functions.
21
22       The  file name is specified in the same way as for shared library names
23       in CREATE FUNCTION [create_function(7)]; in particular, one can rely on
24       a  search  path  and automatic addition of the system's standard shared
25       library file name extension. See in the documentation for more informa‐
26       tion on this topic.
27
28
29       Non-superusers  can  only  apply LOAD to library files located in $lib‐
30       dir/plugins/ — the specified filename  must  begin  with  exactly  that
31       string.  (It  is  the database administrator's responsibility to ensure
32       that only ``safe'' libraries are installed there.)
33

COMPATIBILITY

35       LOAD is a PostgreSQL extension.
36

SEE ALSO

38       CREATE FUNCTION [create_function(7)]
39
40
41
42SQL - Language Statements         2011-09-22                           LOAD(7)