ALTER CONVERSION(7) SQL Commands ALTER CONVERSION(7)NAME
ALTER CONVERSION - change the definition of a conversion
SYNOPSIS
ALTER CONVERSION name RENAME TO newname
ALTER CONVERSION name OWNER TO newowner
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.
newname
The new name of the conversion.
newowner
The new owner of 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)]
SQL - Language Statements 2010-05-14 ALTER CONVERSION(7)
Check Out this Related Man Page
ALTER OPERATOR CLASS(7) SQL Commands ALTER OPERATOR CLASS(7)NAME
ALTER OPERATOR CLASS - change the definition of an operator class
SYNOPSIS
ALTER OPERATOR CLASS name USING index_method RENAME TO newname
ALTER OPERATOR CLASS name USING index_method OWNER TO newowner
DESCRIPTION
ALTER OPERATOR CLASS changes the definition of an operator class.
You must own the operator class to use ALTER OPERATOR CLASS. 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 operator class's schema. (These restrictions enforce that altering the owner
doesn't do anything you couldn't do by dropping and recreating the operator class. However, a superuser can alter ownership of any operator
class anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing operator class.
index_method
The name of the index method this operator class is for.
newname
The new name of the operator class.
newowner
The new owner of the operator class.
COMPATIBILITY
There is no ALTER OPERATOR CLASS statement in the SQL standard.
SEE ALSO
CREATE OPERATOR CLASS [create_operator_class(7)], DROP OPERATOR CLASS [drop_operator_class(7)], ALTER OPERATOR FAMILY [alter_operator_fam-
ily(7)]
SQL - Language Statements 2010-05-14 ALTER OPERATOR CLASS(7)
sscanf() is used in c for inmemory conversion. Is there any routine provided in c++ that allows us to perform the same task(i.e inmemory conversion) as performed by sscanf in c.
I f any one knows plz tell me about it. Thanks. (0 Replies)
Hello..
I have a file containg as below:
My need is to sum the values...
but the error is showing as interger conversion..so i put int() but again not working..please help..here is my code
Thanks in advance
esham (7 Replies)
Hi all,
It will be very useful If you spare some time with me for this worrying error.
I am calling a conversion program which is written in C++ for converting a file format to different format. It was working fine for this past 2 yrs. But now it is not working since the file size has been... (1 Reply)
I guess the subject asks it all, but I am wondering (before I go and code a COBOL module) if conversion of regular ASCII data to COMP-3 is possible on a UNIX environment (AIX 5.1)? Any help would be appreciated! Thanks, Dave (13 Replies)
Hi all,
I have a requirement to convert a file from one format to another.
Parent file:
to
i.e.,
1.) all the lines which begin with "Sample:", should be converted in such a way that entire text after ":" gets converted into all-lower case.
2.) all the lines which begin with... (7 Replies)
Hi ,
we have a string with yyyymmdd format .
how to know which date it is ?
example:20120712-->sunday
20150228-->saturday
20140431-->invalid
please suggest commands which work on below
os : SunOS 5.10
shell: bash shell
Thanks,
Srinath. (10 Replies)