load.7

PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开发团队说,该版本将加速更多企业向该数据库移植.核心开发成员之一Bruce Momjian表示,在新版PostgreSQL

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "LOAD" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
LOAD \- load or reload a shared library file

.SH SYNOPSIS
.sp
.nf
LOAD '\fIfilename\fR'
.sp
.fi
.SH "DESCRIPTION"
.PP
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 [\fBcreate_function\fR(7)]
command.
.PP
The file name is specified in the same way as for shared library
names in CREATE FUNCTION [\fBcreate_function\fR(7)]; in particular, one
may rely on a search path and automatic addition of the system's standard
shared library file name extension. See in the documentation for
more information on this topic.

.PP
Non-superusers may only apply \fBLOAD\fR to library files
located in \fI$libdir/plugins/\fR \(em the specified
\fIfilename\fR must begin
with exactly that string. (It is the database administrator's
responsibility to ensure that only ``safe'' libraries
are installed there.)
.SH "COMPATIBILITY"
.PP
\fBLOAD\fR is a PostgreSQL
extension.
.SH "SEE ALSO"
.PP
CREATE FUNCTION [\fBcreate_function\fR(7)]