What are string constants in PostgreSQL?

devquora

devquora

Posted On: Feb 22, 2018

3 Answers Written

Answered by Priyag Chaudhary
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.
Answered by Renjith
Good experience
Answered by Renjith
Good experience for quiz

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related Questions

List some of the features of Postgresql ?

Following are some of the features of Postgresql : Object-relational database Support and Extensibility for SQL fle..

What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

The SQL standard is defined by four levels of transaction isolation basically regarding three phenomena. The three phe..

Put some light on Multi-Version concurrency control?

MVCC or better known as Multi-version concurrency control is used to avoid unwanted locking of the database. The time ..