PostgreSQL QUOTE IDENT

Postgresql quote_ident

Add a neccessary quote to be used as an identifier in an SQL statement string.

Syntax quote_ident

quote_ident(string)

Example 1

test2=# SELECT quote_ident('good man');
 quote_ident 
-------------
 "good man"
(1 row)

Example 2

test2=# SELECT user_firstname,
test2-# quote_ident(user_firstname)
test2-# FROM profile;
 user_firstname | quote_ident 
----------------+-------------
 Jim            | "Jim"
 king           | king
 Jammi          | "Jammi"
 Bob            | "Bob"
                | 
(5 rows)

Related Links

• Postgresql String Functions
• Learning PostgreSQL
• Tutorial Home

---

• string concate
• bit_length
• char_length
• character_length
• lower
• octet_length
• overlay
• position
• substring
• trim
• upper
• ascii
• btrim

• chr
• concat
• concat_ws
• convert
• convert_from
• convert_to
• decode
• encode
• format
• initcap
• left
• length

• lpad
• ltrim
• md5
• pg_client_encoding
• quote_ident
• quote_literal

• quote_nullable
• regexp_matches
• regexp_replace
• regexp_split_to_array
• regexp_split_to_table

• repeat
• replace
• reverse
• right
• rpad
• rtrim
• split_part
• strpos
• substr
• to_ascii
• to_hex
• translate