aboutsummaryrefslogtreecommitdiff
path: root/src/include/commands/tablespace.h
diff options
context:
space:
mode:
authorStephen Frost <sfrost@snowman.net>2014-01-18 18:56:40 -0500
committerStephen Frost <sfrost@snowman.net>2014-01-18 18:56:40 -0500
commit76e91b38ba64e1da70ea21744b342cb105ea3400 (patch)
treebc485da708d31d5484d5a3de6489cf73684a9640 /src/include/commands/tablespace.h
parent6f25c62d788ea6312fe718ed57a3d169d8efc066 (diff)
downloadpostgresql-76e91b38ba64e1da70ea21744b342cb105ea3400.tar.gz
postgresql-76e91b38ba64e1da70ea21744b342cb105ea3400.zip
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/tablespace.h')
-rw-r--r--src/include/commands/tablespace.h1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/include/commands/tablespace.h b/src/include/commands/tablespace.h
index c7af55917d7..1603f677a7d 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);