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

• Table, foreign table, external table, show table, Delete rows of a table, Table Partitioning (PARTITION BY RANGE), \dt, Hash table, CREATE TABLE, DROP TABLE, ALTER TABLE, SHOW TABLES, TRUNCATE
• ALTER, ALTER DATABASE, ALTER TABLE, ALTER DEFAULT PRIVILEGES, ALTER MATERIALIZED VIEW