1ALTER TABLESPACE(7) PostgreSQL 14.3 Documentation ALTER TABLESPACE(7)
2
3
4
6 ALTER_TABLESPACE - change the definition of a tablespace
7
9 ALTER TABLESPACE name RENAME TO new_name
10 ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
11 ALTER TABLESPACE name SET ( tablespace_option = value [, ... ] )
12 ALTER TABLESPACE name RESET ( tablespace_option [, ... ] )
13
15 ALTER TABLESPACE can be used to change the definition of a tablespace.
16
17 You must own the tablespace to change the definition of a tablespace.
18 To alter the owner, you must also be a direct or indirect member of the
19 new owning role. (Note that superusers have these privileges
20 automatically.)
21
23 name
24 The name of an existing tablespace.
25
26 new_name
27 The new name of the tablespace. The new name cannot begin with pg_,
28 as such names are reserved for system tablespaces.
29
30 new_owner
31 The new owner of the tablespace.
32
33 tablespace_option
34 A tablespace parameter to be set or reset. Currently, the only
35 available parameters are seq_page_cost, random_page_cost,
36 effective_io_concurrency and maintenance_io_concurrency. Setting
37 these values for a particular tablespace will override the
38 planner's usual estimate of the cost of reading pages from tables
39 in that tablespace, and the executor's prefetching behavior, as
40 established by the configuration parameters of the same name (see
41 seq_page_cost, random_page_cost, effective_io_concurrency,
42 maintenance_io_concurrency). This may be useful if one tablespace
43 is located on a disk which is faster or slower than the remainder
44 of the I/O subsystem.
45
47 Rename tablespace index_space to fast_raid:
48
49 ALTER TABLESPACE index_space RENAME TO fast_raid;
50
51 Change the owner of tablespace index_space:
52
53 ALTER TABLESPACE index_space OWNER TO mary;
54
56 There is no ALTER TABLESPACE statement in the SQL standard.
57
59 CREATE TABLESPACE (CREATE_TABLESPACE(7)), DROP TABLESPACE
60 (DROP_TABLESPACE(7))
61
62
63
64PostgreSQL 14.3 2022 ALTER TABLESPACE(7)