LOAD() SQL Commands LOAD()
NAME
LOAD - load or reload a shared library file
SYNOPSIS
LOAD 'filename'
DESCRIPTION
This command loads a shared library file into the PostgreSQL server's
address space. If the file had been loaded previously, it is first
unloaded. This command is primarily useful to unload and reload a
shared library file that has been changed since the server first loaded
it. To make use of the shared library, function(s) in it need to be
declared using the CREATE FUNCTION [create_function(l)] command.
The file name is specified in the same way as for shared library names
in CREATE FUNCTION [create_function(l)]; in particular, one can rely on
a search path and automatic addition of the system's standard shared
library file name extension. See in the documentation for more informa-
tion on this topic.
Non-superusers can only apply LOAD to library files located in $lib-
dir/plugins/ -- the specified filename must begin with exactly that
string. (It is the database administrator's responsibility to ensure
that only ``safe'' libraries are installed there.)
COMPATIBILITY
LOAD is a PostgreSQL extension.
SEE ALSO
CREATE FUNCTION [create_function(l)]
SQL - Language Statements 2008-09-19 LOAD()
postgresql 8.3.4 - Generated Sat Oct 4 06:25:31 CDT 2008