Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

alter_conversion(7) [centos 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)

Check Out this Related Man Page

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)
Man Page

10 More Discussions You Might Find Interesting

1. Programming

inmemory conversion equivalent in c++

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)
Discussion started by: kinnaree
0 Replies

2. Shell Programming and Scripting

conversion to integer not working

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)
Discussion started by: esham
7 Replies

3. Shell Programming and Scripting

error during run: St9bad_alloc - Getting this error while using some conversion progr

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)
Discussion started by: sathu_pec
1 Replies

4. Shell Programming and Scripting

ascii to ebcdic conversion

Hello, I need a program for ascii to ebsdic conversion. If anybody can help, it'll be greatly appreciated. Thanks. (1 Reply)
Discussion started by: er_ashu
1 Replies

5. Shell Programming and Scripting

Comp-3 conversion possible with Shell Scripting or PERL?

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)
Discussion started by: dfran1972
13 Replies

6. Shell Programming and Scripting

if you can help me

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)
Discussion started by: nwar
1 Replies

7. Programming

conversion to 'char' from 'int' warning

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)
Discussion started by: kajolo
4 Replies

8. Programming

Runtime error in my code...

INFIX TO POSTFIX CONVERSION : //Convert an infix expression to postfix expression... #include<iostream> #include<cstring> #include<cstdlib> using namespace std; char ifx,pfx,stk; int top=-1,n; void push(char ch) { if(top!=n-1) { top++; stk=ch; } ... (3 Replies)
Discussion started by: poonam.gaigole
3 Replies

9. UNIX for Dummies Questions & Answers

Selective case conversion of a file

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)
Discussion started by: dipanchandra
7 Replies

10. UNIX for Beginners Questions & Answers

Date conversion

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)
Discussion started by: srinadhreddy27
10 Replies