Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

load(7) [centos man page]

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)
Man Page

14 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

LOAD BALANCING (Experienced help needed)

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)
Discussion started by: TRUEST
6 Replies

2. SCO

Creation of Shared library

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)
Discussion started by: sarangb
0 Replies

3. Linux

load error while creating shared library

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)
Discussion started by: masg1
0 Replies

4. UNIX for Dummies Questions & Answers

The value in TOP command

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)
Discussion started by: nickk
1 Replies

5. Shell Programming and Scripting

unix script for loading a data from a file into database

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)
Discussion started by: grajesh_955
5 Replies

6. Shell Programming and Scripting

sh and MySQL LOAD DATA

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)
Discussion started by: worchyld
18 Replies

7. Shell Programming and Scripting

How to delete a string pattern in a file and write back to the same file

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)
Discussion started by: mwrg
1 Replies

8. UNIX for Advanced & Expert Users

Problem with AIX: shared libraries aren't loaded

(4 Replies)
Discussion started by: edgarvm
4 Replies

9. Shell Programming and Scripting

System Health - Cpu, Load, IO Monitor

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)
Discussion started by: SkySmart
1 Replies

10. HP-UX

Problem in Shared library file .sl on 64bit HP-UX 11.11

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)
Discussion started by: amodkavi
1 Replies

11. Programming

PostgreSQL - can not find server

(1 Reply)
Discussion started by: barlom
1 Replies

12. Solaris

Determining PostgreSQL version

I need to find out if a version of PostgreSQL installed in SPARC Solaris is > 7.2 please tell me how to do it. thanks. (4 Replies)
Discussion started by: orange47
4 Replies

13. Shell Programming and Scripting

SQLLDR :Data not loaded completely

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)
Discussion started by: Pratiksha Mehra
3 Replies

14. UNIX for Beginners Questions & Answers

Replace only First Word in Line

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)
Discussion started by: kaushik02018
1 Replies