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

NAME

6       LOAD - load or reload 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 had been  loaded  previously,  it  is  first
16       unloaded.  This  command  is  primarily  useful  to unload and reload a
17       shared library file that has been changed since the server first loaded
18       it.  To  make  use  of the shared library, function(s) in it need to be
19       declared using the CREATE FUNCTION [create_function(7)] command.
20
21       The file name is specified in the same way as for shared library  names
22       in CREATE FUNCTION [create_function(7)]; in particular, one may rely on
23       a search path and automatic addition of the  system's  standard  shared
24       library file name extension. See in the documentation for more informa‐
25       tion on this topic.
26
27
28       Non-superusers may only apply LOAD to library files  located  in  $lib‐
29       dir/plugins/  —  the  specified  filename  must begin with exactly that
30       string. (It is the database administrator's  responsibility  to  ensure
31       that only ``safe'' libraries are installed there.)
32

COMPATIBILITY

34       LOAD is a PostgreSQL extension.
35

SEE ALSO

37       CREATE FUNCTION [create_function(7)]
38
39
40
41SQL - Language Statements         2008-06-08                            LOAD()