Materialize Logo

text Data Type

text data expresses a Unicode string. This is equivalent to string or varchar in other RDBMSes.

Detail Info
Quick Syntax 'foo'
Size Variable

Syntax

Standard

' text '

To escape a single quote character (') in a standard string literal, write two adjacent single quotes:

SELECT 'single''quote' AS output
   output
------------
single'quote

All other characters are taken literally.

Escape

A string literal that is preceded by an e or E is an “escape” string literal:

e E ' escapable_text '

Escape string literals follow the same rules as standard string literals, except that backslash character (\) starts an escape sequence. The following escape sequences are recognized:

Escape sequence Meaning
\b Backspace
\f Form feed
\n Newline
\r Carriage return
\t Tab
\uXXXX, \UXXXXXXXX Unicode codepoint, where X is a hexadecimal digit

Any other character following a backslash is taken literally, so \\ specifies a literal backslash, and \' is an alternate means of escaping the single quote character.

Unlike in PostgreSQL, there are no escapes that produce arbitrary byte values, in order to ensure that escape string literals are always valid UTF-8.

Details

Valid casts

From text

You can cast text to all types. Casts from text will error if the string is not valid input for the destination type.

To text

You can cast all types to text.

Examples

SELECT 'hello' AS text_val;
 text_val
---------
 hello

SELECT E'behold\nescape strings\U0001F632' AS escape_val;
   escape_val
-----------------
 behold         +
 escape strings­čś▓