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)
Check Out this Related Man Page
ALTER AGGREGATE(7) PostgreSQL 9.2.7 Documentation ALTER AGGREGATE(7)NAME
ALTER_AGGREGATE - change the definition of an aggregate function
SYNOPSIS
ALTER AGGREGATE name ( argtype [ , ... ] ) RENAME TO new_name
ALTER AGGREGATE name ( argtype [ , ... ] ) OWNER TO new_owner
ALTER AGGREGATE name ( argtype [ , ... ] ) SET SCHEMA new_schema
DESCRIPTION
ALTER AGGREGATE changes the definition of an aggregate function.
You must own the aggregate function to use ALTER AGGREGATE. To change the schema of an aggregate function, you must also have CREATE
privilege on the new schema. 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 aggregate function's schema. (These restrictions enforce that altering the owner doesn't do anything you
couldn't do by dropping and recreating the aggregate function. However, a superuser can alter ownership of any aggregate function anyway.)
PARAMETERS
name
The name (optionally schema-qualified) of an existing aggregate function.
argtype
An input data type on which the aggregate function operates. To reference a zero-argument aggregate function, write * in place of the
list of input data types.
new_name
The new name of the aggregate function.
new_owner
The new owner of the aggregate function.
new_schema
The new schema for the aggregate function.
EXAMPLES
To rename the aggregate function myavg for type integer to my_average:
ALTER AGGREGATE myavg(integer) RENAME TO my_average;
To change the owner of the aggregate function myavg for type integer to joe:
ALTER AGGREGATE myavg(integer) OWNER TO joe;
To move the aggregate function myavg for type integer into schema myschema:
ALTER AGGREGATE myavg(integer) SET SCHEMA myschema;
COMPATIBILITY
There is no ALTER AGGREGATE statement in the SQL standard.
SEE ALSO
CREATE AGGREGATE (CREATE_AGGREGATE(7)), DROP AGGREGATE (DROP_AGGREGATE(7))
PostgreSQL 9.2.7 2014-02-17 ALTER AGGREGATE(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)
it was Q in my last midterm
1.he asks us to create new schema as the follwing and i do
$ ./new_schema.sh shema_name.sh schema_name field_names
NEW SCHEMA 'shema_name.sh' WITH FIELDS 'schema_name', 'field_names' "list"CREATED.
2.stord in a file called schema.txt
he told us that this file... (1 Reply)
Hi,
I wrote a simple code in C++ converting from UpperToLower case characters. However, my compiler gives me a warning:
"warning: conversion to 'char' from 'int' may alter its value".
Any tips?
I would like to stress, I don't want to load my string into char array.
int ToLower(string... (4 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)