What are string constants in PostgreSQL?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  Sharad Jaiswal
    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.

Related Questions

Please Login or Register to leave a response.

Related Questions

Postgresql Interview 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..

Postgresql Interview Questions

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..

Postgresql Interview Questions

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 ..