Posted On: Feb 22, 2018
A sequence of characters bound by single quotes is contained by string constants. This feature is used when one needs to insert a character or to pass a character to database objects. PostgreSQL allows the usage of single quotes but embedded by a C style backslash. A string constant is a sequence of characters bound together by single quotes instead of double quotes, which is generally the case with string type variables. This feature is mostly used when a character is being inserted or when a character needs to be passed to database objects. This feature is exceptionally important while parsing data. PostgreSQL lets a user use single quotes only when it is embedded by the specific C-style backslash.
Never Miss an Articles from us.
The SQL standard is defined by four levels of transaction isolation basically regarding three phenomena. The three phe..
MVCC or better known as Multi-version concurrency control is used to avoid unwanted locking of the database. The time ..