Content-Length: 87555 | pFad | http://postgrespro.com/docs/postgrespro/9.6/sql-end.html

Postgres Pro Standard : Documentation: 9.6: END : Postgres Professional

END

END — commit the current transaction

Synopsis

END [ WORK | TRANSACTION ]

Description

END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a Postgres Pro extension that is equivalent to COMMIT.

Parameters

WORK
TRANSACTION

Optional key words. They have no effect.

Notes

Use ROLLBACK to abort a transaction.

Issuing END when not inside a transaction does no harm, but it will provoke a warning message.

Examples

To commit the current transaction and make all changes permanent:

END;

Compatibility

END is a Postgres Pro extension that provides functionality equivalent to COMMIT, which is specified in the SQL standard.









ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://postgrespro.com/docs/postgrespro/9.6/sql-end.html

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy