ALTER GROUP

An SQL command for modifying name or membership of a role

ALTER GROUP is a historical DDL command for modifying the name or membership of a role

ALTER GROUP was added in PostgreSQL 7.0. It was superseded by ALTER ROLE in PostgreSQL 8.1, though has been retained for backwards compatibility.

Change history

Examples

Basic usage example for ALTER GROUP:

postgres=# ALTER GROUP foo RENAME TO bar;
ALTER ROLE

Categories

DDL, SQL command, Users and roles

See also

ALTER ROLE, CREATE GROUP, DROP GROUP