COMMIT ​

Commit the current transaction block.

COMMIT [ WORK | TRANSACTION ]

WORK and TRANSACTION are both optional keywords; they have no effect.

See also BEGIN.

For example, commit the results of two INSERT statements as part of a single transaction:

premdb=# begin;
BEGIN
premdb=# insert into awayteam select atid,name from team;
INSERT 0 50
premdb=# insert into hometeam select htid,name from team;
INSERT 0 50
premdb=# commit;
COMMIT

Parent topic:SQL Commands