| ascii(text) |
integer |
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 |
Character with the given ASCII
code |
chr(65) |
A |
| convert(string
text, [src_encoding
name,] dest_encoding name) |
text |
Convert string to 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 |
| decode(string
text, type text) |
bytea |
Decode binary data from string
previously encoded with encode(). Parameter type is same
as in encode(). |
decode('MTIzAAE=', 'base64') |
123\000\001 |
| encode(data
bytea, type text) |
text |
Encode binary data to ASCII-only
representation. Supported types are: base64, hex, escape. |
encode('123\\000\\001', 'base64') |
MTIzAAE= |
| initcap(text) |
text |
Convert 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 |
Fill 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, text text) |
text |
Remove the longest string containing only characters
from trim from the start of the string. |
ltrim('zzzytrim','xyz') |
trim |
| pg_client_encoding() |
name |
Current client encoding name. |
pg_client_encoding() |
SQL_ASCII |
| quote_ident(string text) |
text |
Return the given string suitably quoted to be used as an
identifier in an SQL query string. Quotes are added only if necessary (i.e., if the
string contains non-identifier characters or would be case-folded). Embedded quotes
are properly doubled. |
quote_ident('Foo') |
"Foo" |
| quote_literal(string text) |
text |
Return the given string suitably quoted to be used as a
literal in an SQL query string. Embedded quotes and backslashes are properly
doubled. |
quote_literal('O\'Reilly') |
'O''Reilly' |
| repeat(text,
integer) |
text |
Repeat text a number of times |
repeat('Pg', 4) |
PgPgPgPg |
| replace(string
text, from text,
to text) |
text |
Replace all occurrences in string
of substring from with substring to |
replace('abcdefabcdef', 'cd', 'XX') |
abXXefabXXef |
| rpad(string
text, length integer [, fill
text]) |
text |
Fill 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 |
Remove the longest string containing only characters
from trim from the end of the string. |
rtrim('trimxxxx','x') |
trim |
| split_part(string text, delimiter text, column integer) |
text |
Split string on delimiter returning the resulting (one based) column number. |
split_part('abc~@~def~@~ghi','~@~',2) |
def |
| strpos(string,
substring) |
text |
Locate specified substring (same as position(substring in string),
but note the reversed argument order) |
strpos('high','ig') |
2 |
| substr(string,
from [, count]) |
text |
Extract specified substring (same as substring(string from from for
count)) |
substr('alphabet', 3, 2) |
ph |
| to_ascii(text
[, encoding]) |
text |
Convert text to ASCII from
other encoding [a] |
to_ascii('Karel') |
Karel |
| to_hex(number
integer or bigint) |
text |
Convert number to its
equivalent hexadecimal representation |
to_hex(9223372036854775807::bigint) |
7fffffffffffffff |
| 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 |
