LOAD(7) SQL Commands LOAD(7)NAME
LOAD - load or reload a shared library file
SYNOPSIS
LOAD 'filename'
DESCRIPTION
Loads a shared library file into the PostgreSQL backend's address space. If the file had been loaded previously, it is first unloaded. This
command is primarily useful to unload and reload a shared library file that has been changed since the backend first loaded it. To make use
of the shared library, function(s) in it need to be declared using the CREATE FUNCTION [create_function(7)] command.
The file name is specified in the same way as for shared library names in CREATE FUNCTION [create_function(7)]; in particular, one may rely
on a search path and automatic addition of the system's standard shared library file name extension. See the Programmer's Guide for more
detail.
COMPATIBILITY
LOAD is a PostgreSQL extension.
SEE ALSO
CREATE FUNCTION [create_function(7)], PostgreSQL Programmer's Guide
SQL - Language Statements 2002-11-22 LOAD(7)
Check Out this Related Man Page
CREATE CONVERSION(7) SQL Commands CREATE CONVERSION(7)NAME
CREATE CONVERSION - define a new encoding conversion
SYNOPSIS
CREATE [ DEFAULT ] CONVERSION name
FOR source_encoding TO dest_encoding FROM funcname
DESCRIPTION
CREATE CONVERSION defines a new conversion between character set encodings. Also, conversions that are marked DEFAULT can be used for auto-
matic encoding conversion between client and server. For this purpose, two conversions, from encoding A to B and from encoding B to A, must
be defined.
To be able to create a conversion, you must have EXECUTE privilege on the function and CREATE privilege on the destination schema.
PARAMETERS
DEFAULT
The DEFAULT clause indicates that this conversion is the default for this particular source to destination encoding. There should be
only one default encoding in a schema for the encoding pair.
name The name of the conversion. The conversion name can be schema-qualified. If it is not, the conversion is defined in the current
schema. The conversion name must be unique within a schema.
source_encoding
The source encoding name.
dest_encoding
The destination encoding name.
funcname
The function used to perform the conversion. The function name can be schema-qualified. If it is not, the function will be looked up
in the path.
The function must have the following signature:
conv_proc(
integer, -- source encoding ID
integer, -- destination encoding ID
cstring, -- source string (null terminated C string)
internal, -- destination (fill with a null terminated C string)
integer -- source string length
) RETURNS void;
NOTES
Use DROP CONVERSION to remove user-defined conversions.
The privileges required to create a conversion might be changed in a future release.
EXAMPLES
To create a conversion from encoding UTF8 to LATIN1 using myfunc:
CREATE CONVERSION myconv FOR 'UTF8' TO 'LATIN1' FROM myfunc;
COMPATIBILITY
CREATE CONVERSION is a PostgreSQL extension. There is no CREATE CONVERSION statement in the SQL standard.
SEE ALSO
ALTER CONVERSION [alter_conversion(7)], CREATE FUNCTION [create_function(7)], DROP CONVERSION [drop_conversion(7)]
SQL - Language Statements 2010-05-14 CREATE CONVERSION(7)
I have followed instructions to get the jdk for sparc, 1.3 loaded on this sparc workstation machine. I used a tar file and everything seemed to go fine. The usr/j2se directory was created with all the subdirectories and java files. However, attempting to run Java commands fails with a file not... (18 Replies)
Hello,
I have a problem with a server. I have access to 2 different root accounts, and they appear to be stuck doing something with sh. I also could not get to the machine with ssh as I usually do; I had to use rlogin.
Here is what happens when I try to su to a root acount:
-bash-3.00$ su... (23 Replies)
Matez,
I have a list of process id's in a text file. I want to know how to find the idle time of a process which are more than 300secs and kill them accordingly.
Could you please help me to get these details. I want to write a shell script with this.
Thanks..Krish :) (36 Replies)
Hi folks,
How can I change a terminal to display different things in different collors.. for example, folders in blue, scripts in green... as it works in Linux??
Thanks for any tip!
Fernanda (21 Replies)
I have a installed Redhat Linux v5 on a new HP Pavillon PC. It has a dual boot with Vista. Booting from Vista, I can connect to the internet. However with Redhat I cannot connect to the internet.
I looked at the /etc/resolv.conf file in Redhat and there is no DNS entry there. From where do I... (28 Replies)
Every day i ftp tar.gz a file from the production server to a back up machine.. This task creates way to much traffic on the network at the end of the day and puts and undo load on the production machine during operation hours. i would like to create a script that would automatically fire off the... (36 Replies)
Hello guys,
i'm searching for a solution how to download all files from root-directory of an ftp-server through an ftp proxy
getting through the ftp proxy and download one file with get ist no problem, but mget * does nothing!
ftp -n -i -v <<EOF
open proxyHost proxyPort
user... (19 Replies)
Hi
I am writing a script to check wheather the web page is up and running. I dont want to download the web page.. I
I used wget --spider command. but i am not getting anything.
can some one tell me the command to the web page..
if the page is up and running I should send a mail to my... (19 Replies)
Hi there,
I've got my own domain, ftp etc.. I'm using cPanel and I want to download a file periodically, every say 24 hours.
I've used this command:
wget -t inf http : / / www . somesite . com / webcam.jpg
ftp : / / i @ MyDomain . net : Password @ ftp . MyDomain . net^no spaces... (24 Replies)
Hey, I recently installed Debian on a desktop PC but when it starts I can't see anything (the monitor say no signal). I don't have any idea or even a way to figure out what going on here since I can't see anything at all not even the console. Is there something that I missed in the install, or is... (22 Replies)
Sorry guys but let me start off by saying I am an AIX noob! I am running AIX 6.1 and recently purchased two iSCSI TOE cards. The plan is to connect these two cards to a Dell EqualLogic SAN and that has two volumes configured for logs and data.
The point of the two cards is to do load balancing... (21 Replies)
Hello,
Im downloading the file from windows server through FTP, the downloaded file is containing some junk character at very start of the file as below and causing my whole script is to fail,
how to download without junk or how to remove these before processing it?
▒▒"nmdbfnmdsfsdf"
... (19 Replies)
Here is a chance for Linux users to easily compare Linux CPU info and some meaningless BOGOMIPS. Everyone who is running Linux is welcome to:
cat /proc/cpuinfo
and post the results.
Here is the results for www.unix.com:
processor : 0
vendor_id : AuthenticAMD
cpu family... (182 Replies)
I'm under huge pressure to recover data from an old server that only gets booted very infrequently. The data on it is urgently required - isn't always??!
..
Server is an HP DL380G5 which is running SCO Unixware 7.11
..
It has 3 partitions in a RAID 5 Configuration: 1 of 10GB (I assume it... (19 Replies)
What is your favorite Linux distro?
and possibly why?
Personally, I have Fedora 3 on my computer. I have used Ubuntu and Slackware, too. But I think I liked Ubuntu more, maybe because of its speed and easy installation of packages. (192 Replies)