[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: ALTER_INDEX.7
File is not writable. Editing disabled.
'\" t .\" Title: ALTER INDEX .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/> .\" Date: 2017-11-06 .\" Manual: PostgreSQL 9.2.24 Documentation .\" Source: PostgreSQL 9.2.24 .\" Language: English .\" .TH "ALTER INDEX" "7" "2017-11-06" "PostgreSQL 9.2.24" "PostgreSQL 9.2.24 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" ALTER_INDEX \- change the definition of an index .\" ALTER INDEX .SH "SYNOPSIS" .sp .nf ALTER INDEX [ IF EXISTS ] \fIname\fR RENAME TO \fInew_name\fR ALTER INDEX [ IF EXISTS ] \fIname\fR SET TABLESPACE \fItablespace_name\fR ALTER INDEX [ IF EXISTS ] \fIname\fR SET ( \fIstorage_parameter\fR = \fIvalue\fR [, \&.\&.\&. ] ) ALTER INDEX [ IF EXISTS ] \fIname\fR RESET ( \fIstorage_parameter\fR [, \&.\&.\&. ] ) .fi .SH "DESCRIPTION" .PP \fBALTER INDEX\fR changes the definition of an existing index\&. There are several subforms: .PP RENAME .RS 4 The RENAME form changes the name of the index\&. There is no effect on the stored data\&. .RE .PP SET TABLESPACE .RS 4 This form changes the index\*(Aqs tablespace to the specified tablespace and moves the data file(s) associated with the index to the new tablespace\&. See also CREATE TABLESPACE (\fBCREATE_TABLESPACE\fR(7))\&. .RE .PP SET ( \fIstorage_parameter\fR = \fIvalue\fR [, \&.\&.\&. ] ) .RS 4 This form changes one or more index\-method\-specific storage parameters for the index\&. See CREATE INDEX (\fBCREATE_INDEX\fR(7)) for details on the available parameters\&. Note that the index contents will not be modified immediately by this command; depending on the parameter you might need to rebuild the index with \fBREINDEX\fR(7) to get the desired effects\&. .RE .PP RESET ( \fIstorage_parameter\fR [, \&.\&.\&. ] ) .RS 4 This form resets one or more index\-method\-specific storage parameters to their defaults\&. As with SET, a REINDEX might be needed to update the index entirely\&. .RE .SH "PARAMETERS" .PP IF EXISTS .RS 4 Do not throw an error if the index does not exist\&. A notice is issued in this case\&. .RE .PP \fIname\fR .RS 4 The name (possibly schema\-qualified) of an existing index to alter\&. .RE .PP \fInew_name\fR .RS 4 The new name for the index\&. .RE .PP \fItablespace_name\fR .RS 4 The tablespace to which the index will be moved\&. .RE .PP \fIstorage_parameter\fR .RS 4 The name of an index\-method\-specific storage parameter\&. .RE .PP \fIvalue\fR .RS 4 The new value for an index\-method\-specific storage parameter\&. This might be a number or a word depending on the parameter\&. .RE .SH "NOTES" .PP These operations are also possible using ALTER TABLE (\fBALTER_TABLE\fR(7))\&. \fBALTER INDEX\fR is in fact just an alias for the forms of \fBALTER TABLE\fR that apply to indexes\&. .PP There was formerly an \fBALTER INDEX OWNER\fR variant, but this is now ignored (with a warning)\&. An index cannot have an owner different from its table\*(Aqs owner\&. Changing the table\*(Aqs owner automatically changes the index as well\&. .PP Changing any part of a system catalog index is not permitted\&. .SH "EXAMPLES" .PP To rename an existing index: .sp .if n \{\ .RS 4 .\} .nf ALTER INDEX distributors RENAME TO suppliers; .fi .if n \{\ .RE .\} .PP To move an index to a different tablespace: .sp .if n \{\ .RS 4 .\} .nf ALTER INDEX distributors SET TABLESPACE fasttablespace; .fi .if n \{\ .RE .\} .PP To change an index\*(Aqs fill factor (assuming that the index method supports it): .sp .if n \{\ .RS 4 .\} .nf ALTER INDEX distributors SET (fillfactor = 75); REINDEX INDEX distributors; .fi .if n \{\ .RE .\} .SH "COMPATIBILITY" .PP \fBALTER INDEX\fR is a PostgreSQL extension\&. .SH "SEE ALSO" CREATE INDEX (\fBCREATE_INDEX\fR(7)), \fBREINDEX\fR(7)
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: server05.hostinghome.co.in
Server IP: 192.168.74.40
PHP Version: 7.4.33
Server Software: Apache
System: Linux server05.hostinghome.co.in 3.10.0-962.3.2.lve1.5.81.el7.x86_64 #1 SMP Wed May 31 10:36:47 UTC 2023 x86_64
HDD Total: 1.95 TB
HDD Free: 690.71 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Disabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes
gcc:
Yes
pkexec:
No
git:
Yes
User Info
Username: itsweb
User ID (UID): 1619
Group ID (GID): 1621
Script Owner UID: 1619
Current Dir Owner: N/A