2 $PostgreSQL: pgsql/doc/src/sgml/ref/load.sgml,v 1.21 2005/01/04 00:39:53 tgl Exp $
5 <refentry id="SQL-LOAD">
7 <refentrytitle id="SQL-LOAD-TITLE">LOAD</refentrytitle>
8 <refmiscinfo>SQL - Language Statements</refmiscinfo>
12 <refname>LOAD</refname>
13 <refpurpose>load or reload a shared library file</refpurpose>
16 <indexterm zone="sql-load">
17 <primary>LOAD</primary>
22 LOAD '<replaceable class="PARAMETER">filename</replaceable>'
26 <refsect1 id="sql-load-description">
27 <title>Description</title>
30 This command loads a shared library file into the <productname>PostgreSQL</>
31 server's address space. If the file had been loaded previously,
32 it is first unloaded. This command is primarily useful to unload
33 and reload a shared library file that has been changed since the
34 server first loaded it. To make use of the shared library,
35 function(s) in it need to be declared using the <xref
36 linkend="sql-createfunction" endterm="sql-createfunction-title">
41 The file name is specified in the same way as for shared library
42 names in <xref linkend="sql-createfunction" endterm="sql-createfunction-title">; in particular, one
43 may rely on a search path and automatic addition of the system's standard
44 shared library file name extension. See <xref linkend="xfunc-c"> for
45 more information on this topic.
49 <refsect1 id="sql-load-compat">
50 <title>Compatibility</title>
53 <command>LOAD</command> is a <productname>PostgreSQL</productname>
60 <title>See Also</title>
63 <xref linkend="sql-createfunction" endterm="sql-createfunction-title">
68 <!-- Keep this comment at the end of the file
73 sgml-minimize-attributes:nil
74 sgml-always-quote-attributes:t
77 sgml-parent-document:nil
78 sgml-default-dtd-file:"../reference.ced"
80 sgml-local-catalogs:"/usr/lib/sgml/catalog"
81 sgml-local-ecat-files:nil