Name
LOAD
-- Dynamically loads object files into a database.
Synopsis
LOAD 'filename'
Parameters
- filename
Use this parameter to specify the filename of the dynamic object file you wish to load.
Results
- LOAD
This message is displayed if the dynamic object file was successfully loaded.
Message returned upon successful completion.
- ERROR: LOAD: could not open file 'filename'
This error is displayed if the specified file was not found. Make sure PostgreSQL
backend is permitted to access the file.
Description
Use this command to load an object file into the PostgreSQL backend. Once loaded, an object file provides
the backend whatever functionality the file was created for. In this way, you can incorporate your own
database components (such as types and functions) dynamically. If you do not explicitly load an object file,
the backend will load it automatically when a function from the file is called. Currently, the only object
files support are C language files.
 | Reloading Object Files |
|---|
| | You can also use this command to force the reloading of recently recompiled object files.
|
Examples
The following example loads the file /usr/local/pgsql/code/miscfunctions.o.
LOAD '/usr/local/pgsql/code/miscfunctions.o'