diff options
| author | Stephen Frost <sfrost@snowman.net> | 2014-01-18 18:56:40 -0500 |
|---|---|---|
| committer | Stephen Frost <sfrost@snowman.net> | 2014-01-18 18:56:40 -0500 |
| commit | 76e91b38ba64e1da70ea21744b342cb105ea3400 (patch) | |
| tree | bc485da708d31d5484d5a3de6489cf73684a9640 /src/include/commands | |
| parent | 6f25c62d788ea6312fe718ed57a3d169d8efc066 (diff) | |
| download | postgresql-76e91b38ba64e1da70ea21744b342cb105ea3400.tar.gz | |
Add ALTER TABLESPACE ... MOVE command
This adds a 'MOVE' sub-command to ALTER TABLESPACE which allows moving sets of
objects from one tablespace to another. This can be extremely handy and avoids
a lot of error-prone scripting. ALTER TABLESPACE ... MOVE will only move
objects the user owns, will notify the user if no objects were found, and can
be used to move ALL objects or specific types of objects (TABLES, INDEXES, or
MATERIALIZED VIEWS).
Diffstat (limited to 'src/include/commands')
| -rw-r--r-- | src/include/commands/tablespace.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/include/commands/tablespace.h b/src/include/commands/tablespace.h index c7af55917d..1603f677a7 100644 --- a/src/include/commands/tablespace.h +++ b/src/include/commands/tablespace.h @@ -43,6 +43,7 @@ extern Oid CreateTableSpace(CreateTableSpaceStmt *stmt); extern void DropTableSpace(DropTableSpaceStmt *stmt); extern Oid RenameTableSpace(const char *oldname, const char *newname); extern Oid AlterTableSpaceOptions(AlterTableSpaceOptionsStmt *stmt); +extern Oid AlterTableSpaceMove(AlterTableSpaceMoveStmt *stmt); extern void TablespaceCreateDbspace(Oid spcNode, Oid dbNode, bool isRedo); |