DROP CONVERSION(7) SQL Commands DROP CONVERSION(7)NAME
DROP CONVERSION - remove a conversion
SYNOPSIS
DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DESCRIPTION
DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion.
PARAMETERS
IF EXISTS
Do not throw an error if the conversion does not exist. A notice is issued in this case.
name The name of the conversion. The conversion name can be schema-qualified.
CASCADE
RESTRICT
These key words do not have any effect, since there are no dependencies on conversions.
EXAMPLES
To drop the conversion named myname:
DROP CONVERSION myname;
COMPATIBILITY
There is no DROP CONVERSION statement in the SQL standard.
SEE ALSO
ALTER CONVERSION [alter_conversion(7)], CREATE CONVERSION [create_conversion(7)]
SQL - Language Statements 2010-05-14 DROP CONVERSION(7)
Check Out this Related Man Page
CREATE CONVERSION(7) SQL Commands CREATE CONVERSION(7)NAME
CREATE CONVERSION - define a user-defined conversion
SYNOPSIS
CREATE [DEFAULT] CONVERSION conversion_name
FOR source_encoding TO dest_encoding FROM funcname
DESCRIPTION
CREATE CONVERSION defines a new encoding conversion. Conversion names may be used in the CONVERT() function to specify a particular encod-
ing conversion. Also, conversions that are marked DEFAULT can be used for automatic encoding conversion between frontend and backend. 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 the execute right on the function and the create right on the destination schema. "PARAM-
ETERS"
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.
conversion_name
The name of the conversion. The conversion name may 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.
source_encoding
The destination encoding name.
funcname
The function used to perform the conversion. The function name may 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)
CSTRING, -- destination string (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 may be changed in a future release.
EXAMPLES
To create a conversion from encoding UNICODE to LATIN1 using myfunc:
CREATE CONVERSION myconv FOR 'UNICODE' TO 'LATIN1' FROM myfunc;
COMPATIBILITY
CREATE CONVERSION is a PostgreSQL extension. There is no CREATE CONVERSION statement in SQL99.
SEE ALSO
CREATE FUNCTION [create_function(7)], DROP CONVERSION [drop_conversion(7)], PostgreSQL Programmer's Guide
SQL - Language Statements 2002-11-22 CREATE CONVERSION(7)
Hi all,
I want to create a new user and grant him ONLY transfer files access to a specific directory where he can only upload and read the files. He should be restricted to this activity only.
Regards (6 Replies)
Hi everyone,
I know the following questions are noobish questions but I am asking them because I am confused about the basics of history behind UNIX and LINUX.
Ok onto business, my questions are-:
Was/Is UNIX ever an open source operating system ?
If UNIX was... (21 Replies)
Hi,
Last 2 weeks I have searched many forums and i haven't found the answer for the question:
How to get all command output to Putty title?
Needed it for other programs to know when some jobs on a server is done and is it done right or wrong. Plink stdout and stdin wasn't working, i used many... (1 Reply)
anyone have any idea how do to this with auth_attr?
I suspect if I grant him
solaris.device.:RO::Device Allocation::help=DevAllocHeader.html
that will work but I'm unsure. Just looking for a second opinion. (10 Replies)
I am looking for a stable, reliable system to replace my current Windows systems in the home. These are simple systems that I purchased from the local Big Box store.
I have heard many good things about Unix and it's various children and it sounds like a good option to me. I have worked... (2 Replies)
We have a lot of scripts using cut as :
cut -c 0-8 --works for cut (GNU coreutils) 5.97, but does not work for cut (GNU coreutils) 8.4.
Gives error -
cut: fields and positions are numbered from 1
Try `cut --help' for more information.
The position needs to start with 1 for later... (6 Replies)
I've got a problem with a proxy configuration. We have an LDAP group that lists all users who are authorised to use the proxy to FTP (usually Filezilla) out to the world, and by implication those not in the group should be denied. My users are delighted that this has been enabled and those that... (9 Replies)
hi folks,
how to using tar with exclude directory and compress it using tar.Z
i only know how to exclude dir only with this command below:
tar -cvf /varios/restore/test.tar -X excludefile.txt /jfma/test1/
how to compress it using 1 command?
Thanx
Please use CODE tags as... (6 Replies)
Hello All,
I had recently learnt a bit of Docker(which provides containerization process).
Here are some of my learning points from it.
Let us start first with very basic question:
What is Docker:
Docker is a platform for sysadmins and developers to DEPLOY, DEVELOP and RUN applications ... (7 Replies)
What is the point of this? Whenever I close my shell it appends to the history file without adding this. I have never seen it overwrite my history file.
# When the shell exits, append to the history file instead of overwriting it
shopt -s histappend (3 Replies)
Hello for all,
I am testing the behavior of a 32 bit application running on Solaris 5.10 (SPARC), and realize it reaches 4GB of memory and then crashes.
It doesn't matter the amount of used memory as application is intended to perform many transactions; rather, what I want to achieve is to... (2 Replies)