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;

Related

• List tables: \dt
• Insert into
• Create user

See also

• ALTER, ALTER DATABASE, ALTER DEFAULT PRIVILEGES
• SQL, NewSQL: 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