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)
Check Out this Related Man Page
MODULES-LOAD.D(5) modules-load.d MODULES-LOAD.D(5)NAME
modules-load.d - Configure kernel modules to load at boot
SYNOPSIS
/etc/modules-load.d/*.conf
/run/modules-load.d/*.conf
/usr/lib/modules-load.d/*.conf
DESCRIPTION systemd-modules-load.service(8) reads files from the above directories which contain kernel modules to load during boot in a static list.
Each configuration file is named in the style of /etc/modules-load.d/program.conf. Note that it is usually a better idea to rely on the
automatic module loading by PCI IDs, USB IDs, DMI IDs or similar triggers encoded in the kernel modules themselves instead of static
configuration like this. In fact, most modern kernel modules are prepared for automatic loading already.
CONFIGURATION FORMAT
The configuration files should simply contain a list of kernel module names to load, separated by newlines. Empty lines and lines whose
first non-whitespace character is # or ; are ignored.
Each configuration file shall be named in the style of program.conf. Files in /etc/ override files with the same name in /usr/lib/ and
/run/. Files in /run/ override files with the same name in /usr/lib/. Packages should install their configuration files in /usr/lib/, files
in /etc/ are reserved for the local administrator, who may use this logic to override the configuration files installed from vendor
packages.
If the administrator wants to disable a configuration file supplied by the vendor, the recommended way is to place a symlink to /dev/null
in /etc/modules-load.d/ bearing the same filename.
EXAMPLE
Example 1. /etc/modules-load.d/virtio-net.conf example:
# Load virtio-net.ko at boot
virtio-net
SEE ALSO systemd(1), systemd-modules-load.service(8), systemd-delta(1), modprobe(8)systemd 208MODULES-LOAD.D(5)
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)
Trying to make a library and get this error :
*** Warning: This library needs some functionality provided by -lming32.
*** I have the capability to make that library automatically link in when
*** you link to this library. But I can only do this if you have a
*** shared version of the... (1 Reply)
I am brand new to Unix. This is probably simple, but how do you list the contents of a shared library? I need to see which functions exist in it.
Many thanks. (1 Reply)
I have to replace date in Control file every day i run the script
control file looks like this
$cat pharma.ctl
LOAD DATA
INFILE '/usr/bin/sqlscripts/SQL.PharmID.20071206.txt'
INTO TABLE uname.TEMP_TABLE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(col_names)
i tried
$sed -e... (2 Replies)
I have two envoirmets(Envoirment A and Envoirment B) running on same server(AIX vesion 5.3).Both have different groups.I am facing a strange problem.Shared objects of one envoirment (Envoirment A)are getting loaded into the second(Envoirment B).So the servers that have dependency on shared objects... (2 Replies)
I have a shared library file (.so) and I need to know some information
1. By which GCC version was this .so built?
2. Was this .so built in 32 bits mode or 64 bits mode
Any command / tools to backtrace such kind of information?
Thanks in advance! (2 Replies)
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)
We have a BI shop that uses a shared ETL server and a database cluster for the EDW and several different data marts catering to individual business groups.
Of late, we have noticed that a lot of sloppy code has crept in and the ETL server (and sometimes the DB as well) seems to be maxing out on... (2 Replies)
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)