Alter Table: Computers/Software/Databases

2.2 Alter Table

[ up ] - [ TOC ] - [ A - Z ]

2.3 SELECT examples →

Add a NOT NULL constraint

ALTER TABLE t_example ALTER lang SET NOT NULL;

Rename a column

BEGIN;
LOCK TABLE t_example;
ALTER TABLE t_example RENAME lname TO lastname;
COMMIT;

See also:

PostgreSQL Know-how - Reference
ALTER TABLE ...
See also: know-how/postgresql/alter-table
postgresql.org/files/documentation/books/pghandbuch/html/sql-altertable.html