| ascii(text) | integer | Returns the ASCII code of the first character of the argument. | ascii('x') | 120 |
| btrim(string text, trim text) | text | Remove (trim) the longest string consisting only of characters
in trim from the start and end of
string.
| btrim('xyxtrimyyx','xy') | trim |
| chr(integer) | text | Returns the character with the given ASCII code. | chr(65) | A |
| convert(string text,
[src_encoding name,]
dest_encoding name)
| text | Converts string using dest_encoding.
The original encoding is specified by
src_encoding. If
src_encoding is omitted, database
encoding is assumed.
| convert('text_in_unicode', 'UNICODE', 'LATIN1') | text_in_unicode represented in ISO 8859-1 |
| initcap(text) | text | Converts first letter of each word (whitespace separated) to upper case. | initcap('hi thomas') | Hi Thomas |
| length(string) | integer | length of string
| length('jose') | 4 |
| lpad(string text,
length integer
[, fill text])
| text | Fills up the string to length
length by prepending the characters
fill (a space by default). If the
string is already longer than
length then it is truncated (on the
right).
| lpad('hi', 5, 'xy') | xyxhi |
| ltrim(string text, trim text) | text | Removes the longest string containing only characters from
trim from the start of the string.
| ltrim('zzzytrim','xyz') | trim |
| pg_client_encoding() | name | Returns current client encoding name.
| pg_client_encoding() | SQL_ASCII |
| repeat(text, integer) | text | Repeat text a number of times. | repeat('Pg', 4) | PgPgPgPg |
| rpad(string text,
length integer
[, fill text])
| text | Fills up the string to length
length by appending the characters
fill (a space by default). If the
string is already longer than
length then it is truncated.
| rpad('hi', 5, 'xy') | hixyx |
| rtrim(string text, trim text) | text | Removes the longest string containing only characters from
trim from the end of the string.
| rtrim('trimxxxx','x') | trim |
| strpos(string, substring) | text | Locates specified substring. (same as
position(substring in
string), but note the reversed
argument order)
| strpos('high','ig') | 2 |
| substr(string, from [, count]) | text | Extracts specified substring. (same as substring(string from from for count))
| substr('alphabet', 3, 2) | ph |
| to_ascii(text [, encoding]) | text | Converts text from multibyte encoding to ASCII. | to_ascii('Karel') | Karel |
| translate(string text,
from text,
to text)
| text | Any character in string that matches a
character in the from set is replaced by
the corresponding character in the to
set.
| translate('12345', '14', 'ax') | a23x5 |
| encode(data bytea,
type text)
| text | Encodes binary data to ASCII-only representation. Supported
types are: 'base64', 'hex', 'escape'.
| encode('123\\000\\001', 'base64') | MTIzAAE= |
| decode(string text,
type text)
| bytea | Decodes binary data from string previously
encoded with encode(). Parameter type is same as in encode().
| decode('MTIzAAE=', 'base64') | 123\000\001 |