.\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ ALTER TABLESPACE - Online Linux Manual PageSection : 7
Updated : 2014-02-17
Source : SQL - Language Statements
Note : SQL Commands

---

NAMEALTER TABLESPACE − change the definition of a tablespace

---

SYNOPSISALTER TABLESPACE name RENAME TO newname ALTER TABLESPACE name OWNER TO newowner

---

DESCRIPTIONALTER TABLESPACE changes the definition of a tablespace. You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the new owning role. (Note that superusers have these privileges automatically.)

---

PARAMETERSname  The name of an existing tablespace. newname  The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces. newowner  The new owner of the tablespace.

---

EXAMPLESRename tablespace index_space to fast_raid: ALTER TABLESPACE index_space RENAME TO fast_raid; Change the owner of tablespace index_space: ALTER TABLESPACE index_space OWNER TO mary;

---

COMPATIBILITYThere is no ALTER TABLESPACE statement in the SQL standard.

---

SEE ALSOCREATE TABLESPACE [create_tablespace(7)], DROP TABLESPACE [drop_tablespace(7)] 0

---

Johanes Gumabo

---

Data Size   :   6,043 byte
man-alter_tablespace.7Build   :   2024-12-05, 20:55   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   2 / 198,242
Visitor ID   :     :  
Visitor IP   :   18.227.134.165   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   1000   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.05
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36

---

Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .

---

If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.

---

ERROR : Need New Coding :         (rof_escape_sequence|91|alter_tablespace.7|1|\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ |.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )         (parse_manual_page_|249|alter_tablespace.7|1|\"|.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )    

---