LOAD(7) PostgreSQL 9.2.7 Documentation LOAD(7)NAME
LOAD - load 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 has been loaded already, the command does
nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an
explicit LOAD is usually only needed to load a library that modifies the server's behavior through "hooks" rather than providing a set of
functions.
The file name is specified in the same way as for shared library names in CREATE FUNCTION (CREATE_FUNCTION(7)); in particular, one can rely
on a search path and automatic addition of the system's standard shared library file name extension. See Section 35.9, "C-Language
Functions", in the documentation for more information on this topic.
Non-superusers can only apply LOAD to library files located in $libdir/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(7))
PostgreSQL 9.2.7 2014-02-17 LOAD(7)
Check Out this Related Man Page
LOAD(7) SQL Commands LOAD(7)NAME
LOAD - load 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 has been loaded already, the command does
nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an
explicit LOAD is usually only needed to load a library that modifies the server's behavior through ``hooks'' rather than providing a set of
functions.
The file name is specified in the same way as for shared library names in CREATE FUNCTION [create_function(7)]; 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
information on this topic.
Non-superusers can only apply LOAD to library files located in $libdir/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(7)]
SQL - Language Statements 2010-05-14 LOAD(7)
now, i have been reading alot of books about this load balancing thing. when looking at the output of iostat and one determines that the disks do not have roughly equivalent utilization rate, books i've read mentions balancing the loads so the loads are spread evenly across the disks.
Now, i... (6 Replies)
Hi all,
I am new to sco unix.
I would like to know abt the procedure to create shared library in Sco-unix.
Is it differ from linux?
any help??
Thanx in Advance!!!!! (0 Replies)
Hi,
I am trying to create shared library. When i run the script to build the library i get these errors
ld: warning: option -o appears more than once, first setting taken
ld: fatal: file libgc.so.0: open failed: No such file or directory
ld: fatal: File processing errors. No output written... (0 Replies)
https://www.unix.com/showpost.php?p=98416&postcount=8
Referring to the post above... what is the unit that is measured in the TOP command under LOAD? (1 Reply)
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
I have a csv file in a folder that is roughly 500,000 rows long.
Rather than using PHP, I would like to use SH to run a MYSQL LOAD DATA command to load the data in, as I think it would be much faster and would not cause any memory problems associated with PHP.
But the problem is, I am not... (18 Replies)
I have a control file which looks like this
LOAD DATA
INFILE '/array/data/data_Finished_T5_col_change/home/oracle/emp.dat'
PRESERVE BLANKS
INTO TABLE SCOTT.EMP
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(.................
..................)
How can i edit the... (1 Reply)
hello there,
can someone please tell me the commands that makes sense, from a production point of view, to be used to make sure CPU, LOAD or IO usages on a Linux or Solaris server isn't too high?
I'm aware of vmstat, iostat, sar. But i seriously need real world advice as to what fields in... (1 Reply)
We are facing issue with shared library file, we are getting difference in content for same shared file for chatr command :confused: , below are the detail about *.sl file, even we are also getting difference in size of both file. can you please tell me what will be the issue for same. is my new... (1 Reply)
Hi ,
I am using below control file
LOAD DATA
APPEND
INTO TABLE LSHADMIN.EG
TRAILING NULLCOLS
(
STUDY CHAR
)
and the text file to load data is
CACZ885M2301
When I run below command:
sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
I have query to replace the first word in line using below code but its replace the middle word too
sed -i 's/load /# LOAD/' /tmp/check.sql
Query 1 :
UPDATE accheadcon_data_last_upload SET last_upload_date = '2017-07-23'
Replace to
UPDATE accheadcon_data_last_up# LOAD SET... (1 Reply)