DROP CONVERSION(7) SQL Commands DROP CONVERSION(7)NAME
DROP CONVERSION - remove a user-defined conversion
SYNOPSIS
DROP CONVERSION conversion_name
[ CASCADE | RESTRICT ]
DESCRIPTION
DROP CONVERSION removes a previously defined conversion.
To be able to drop a conversion, you must own the conversion. "PARAMETERS"
conversion_name
The name of the conversion. The conversion name may be schema-qualified.
CASCADE
RESTRICT
These key words do not have any effect, since there are no dependencies on conversions.
NOTES
Use CREATE CONVERSION to create user-defined conversions.
The privileges required to drop a conversion may be changed in a future release.
EXAMPLES
To drop the conversion named myname:
DROP CONVERSION myname;
COMPATIBILITY
DROP CONVERSION is a PostgreSQL extension. There is no DROP CONVERSION statement in SQL99.
SEE ALSO
CREATE CONVERSION [create_conversion(7)]
SQL - Language Statements 2002-11-22 DROP CONVERSION(7)
Check Out this Related Man Page
ALTER CONVERSION(7) PostgreSQL 9.2.7 Documentation ALTER CONVERSION(7)NAME
ALTER_CONVERSION - change the definition of a conversion
SYNOPSIS
ALTER CONVERSION name RENAME TO new_name
ALTER CONVERSION name OWNER TO new_owner
ALTER CONVERSION name SET SCHEMA new_schema
DESCRIPTION
ALTER CONVERSION changes the definition of a conversion.
You must own the conversion to use ALTER CONVERSION. To alter the owner, you must also be a direct or indirect member of the new owning
role, and that role must have CREATE privilege on the conversion's schema. (These restrictions enforce that altering the owner doesn't do
anything you couldn't do by dropping and recreating the conversion. However, a superuser can alter ownership of any conversion anyway.)
PARAMETERS
name
The name (optionally schema-qualified) of an existing conversion.
new_name
The new name of the conversion.
new_owner
The new owner of the conversion.
new_schema
The new schema for the conversion.
EXAMPLES
To rename the conversion iso_8859_1_to_utf8 to latin1_to_unicode:
ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;
To change the owner of the conversion iso_8859_1_to_utf8 to joe:
ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;
COMPATIBILITY
There is no ALTER CONVERSION statement in the SQL standard.
SEE ALSO
CREATE CONVERSION (CREATE_CONVERSION(7)), DROP CONVERSION (DROP_CONVERSION(7))
PostgreSQL 9.2.7 2014-02-17 ALTER CONVERSION(7)
I need to use bash to convert sentences where all words start with a small letter into one where all words start with a capital letter.
So that a string like:
are utilities ready for hurricane sandy
becomes:
Are Utilities Ready For Hurricane Sandy (10 Replies)
Hi
I am new to this forum.
Any please help me to capture ctrl x and ctrl y via a bash script.
and please tell me how to clear the prompt via bash script
BR
Ramukumar M (4 Replies)
I have an Oracle Linux 7.1 vsphere host built. It's be preconfigured with our security configurations.
What I would like to do is unconfigure this host. Then set the host to do firstboot --reconfigure.
how do I do that using /etc/sysconfig/firstboot?
I've tried setting
... (10 Replies)
i know from the command line, the symbol $_ is used to get the last command that was run.
however, id like to replicate this within a script.
meaning, how do i do something like this:
#!/bin/sh
ps -ef | egrep talling
StoreThisLastCommandA=$_
awk '/error/ {print $3}' /tmp/test... (5 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)
Quite an obscure question I think.
We have a rebuild process for remote sites that allows us to PXE rebuild a till (actually a PC with a touch screen and various fancy bits) running CentOS. The current CentOS5 tills work just fine with a tar image restore and some personalisation. Sadly,... (4 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)
Hi Folks,
I feel that I should be posting this in the Unix for Dummies Forum and will probably wish I'd created an account and done just that - but here goes anyway.
I have two identical servers both Dell R430's both running RedHat Enterprise Server 7.4 and the same kernel, both have the same... (16 Replies)
Hi,
What is installation package and how to create it?
When we run:
in AIX:
installp package1
or
in Linux
rpm -ivh mypackage
What is package1 or mypackage in the abov examples and how to create them and deploy them?
I hope my question is clear enough.
Thank you (2 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)
After the success of the jq - tool for parsing and manipulating JSON-Data someone wrote a tool called yq, which aims to be the same for YAML, what jq is for JSON. Seems to work fine. I'll definitely give it a chance in future.
Example YAML-File:
--- !ruby/object:Puppet::Node::Facts
... (1 Reply)