Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

END

Name

END -- Ends the current transaction block and finalizes its modifications.

Synopsis

END [ WORK | TRANSACTION ]

Parameters

WORK | TRANSACTION

A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.

Results

COMMIT

The message returned when a transaction is successfully committed.

NOTICE: COMMIT: no transaction in progress

The notice returned if there is no transaction in progress for the END command to end.

Description

The END command is a synonym for COMMIT. Use it to end transactions the same way you would use the COMMIT command.

Example

The following example demonstrates how to commit a transaction using the END command:

booktown=# 
END WORK;

COMMIT
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire