2
.\" Title: ALTER COLLATION
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "ALTER COLLATION" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
ALTER_COLLATION \- change the definition of a collation
27
ALTER COLLATION \fIname\fR RENAME TO \fInew_name\fR
28
ALTER COLLATION \fIname\fR OWNER TO \fInew_owner\fR
29
ALTER COLLATION \fIname\fR SET SCHEMA \fInew_schema\fR
34
changes the definition of a collation\&.
36
You must own the collation to use
37
ALTER COLLATION\&. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have
39
privilege on the collation\(aqs schema\&. (These restrictions enforce that altering the owner doesn\(aqt do anything you couldn\(aqt do by dropping and recreating the collation\&. However, a superuser can alter ownership of any collation anyway\&.)
44
The name (optionally schema\-qualified) of an existing collation\&.
49
The new name of the collation\&.
54
The new owner of the collation\&.
59
The new schema for the collation\&.
63
To rename the collation
72
ALTER COLLATION "de_DE" RENAME TO german;
78
To change the owner of the collation
87
ALTER COLLATION "en_US" OWNER TO joe;
96
statement in the SQL standard\&.
98
CREATE COLLATION (\fBCREATE_COLLATION\fR(7)), DROP COLLATION (\fBDROP_COLLATION\fR(7))