ALTER ... SWAP
ALTER ... SWAP atomically renames two items.
Syntax
| Field | Use |
|---|---|
| name | The identifier of the item you want to swap. |
| target_name | The target identifier of the item you want to swap with. |
Examples
Swapping two items is useful for a blue/green deployment
CREATE SCHEMA blue;
CREATE TABLE blue.numbers (n int);
CREATE SCHEMA green;
CREATE TABLE green.tags (tag text);
ALTER SCHEMA blue SWAP WITH green;
-- The schema which was previously named 'green' is now named 'blue'.
SELECT * FROM blue.tags;
Privileges
The privileges required to execute this statement are:
- Ownership of both objects being swapped.