|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.103 2002/06/15 20:03:51 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.104 2002/06/24 22:17:01 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -1081,6 +1081,32 @@ PostgreSQL documentation |
1081 | 1081 | <entry><literal>SQL_ASCII</literal></entry> |
1082 | 1082 | </row> |
1083 | 1083 |
|
| 1084 | + <row> |
| 1085 | + <entry><function>quote_ident</function>(<parameter>string</parameter> text)</entry> |
| 1086 | + <entry><type>text</type></entry> |
| 1087 | + <entry> |
| 1088 | + Returns the given string suitably quoted to be used as an identifier |
| 1089 | +in an SQL query string. |
| 1090 | +Quotes are added only if necessary (i.e., if the string contains |
| 1091 | +non-identifier characters or would be case-folded). |
| 1092 | +Embedded quotes are properly doubled. |
| 1093 | + </entry> |
| 1094 | + <entry><literal>quote_ident('Foo')</literal></entry> |
| 1095 | + <entry><literal>"Foo"</literal></entry> |
| 1096 | + </row> |
| 1097 | + |
| 1098 | + <row> |
| 1099 | + <entry><function>quote_literal</function>(<parameter>string</parameter> text)</entry> |
| 1100 | + <entry><type>text</type></entry> |
| 1101 | + <entry> |
| 1102 | + Returns the given string suitably quoted to be used as a literal |
| 1103 | +in an SQL query string. |
| 1104 | +Embedded quotes and backslashes are properly doubled. |
| 1105 | + </entry> |
| 1106 | + <entry><literal>quote_literal('O\'Reilly')</literal></entry> |
| 1107 | + <entry><literal>'O''Reilly'</literal></entry> |
| 1108 | + </row> |
| 1109 | + |
1084 | 1110 | <row> |
1085 | 1111 | <entry><function>repeat</function>(<type>text</type>, <type>integer</type>)</entry> |
1086 | 1112 | <entry><type>text</type></entry> |
|