ALTER TABLE

• https://www.postgresql.org/docs/current/sql-altertable.html

ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE (columns);

ALTER TABLE tablename OWNER TO "new-owner";

REVOKE ALL ON accounts FROM PUBLIC;

ALTER TABLE … SET (toast_tuple_target = N)

ALTER TABLE measurement DETACH PARTITION measurement_y2006m02;
ALTER TABLE measurement DETACH PARTITION measurement_y2006m02 CONCURRENTLY;

Related

• List tables: \dt
• Insert into
• Create user
• Must be owner of table

See also

• ALTER, ALTER DATABASE, ALTER TABLE, ALTER DEFAULT PRIVILEGES, ALTER MATERIALIZED VIEW
• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql