pg_escape_literal
pg_escape_literal escapes a literal for querying the PostgreSQL database. It returns an escaped literal in the PostgreSQL format. pg_escape_literal adds quotes before and after data. Users should not add quotes. Use of this function is recommended instead of pg_escape_string. If the type of the column is bytea, pg_escape_bytea must be used instead. For escaping identifiers (e.g. table, field names), pg_escape_identifier must be used.
Note:
This function has internal escape code and can also be used with PostgreSQL 8.4 or less.
Parameters
- connection
-
An PgSql\Connection instance. When connection is unspecified, the default connection is used. The default connection is the last connection made by pg_connect or pg_pconnect.
Warning:
As of PHP 8.1.0, using the default connection is deprecated.
- data
-
A string containing text to be escaped.
Return Values
A string containing the escaped data.
Changelog
| Version | Description |
| 8.1.0 | The connection parameter expects an PgSql\Connection instance now; previously, a resource was expected. |