pg_end_copy
(PHP 4 >= 4.0.3)
pg_end_copy -- Sync with PostgreSQL backend
Description
bool pg_end_copy ( [resource connection])
pg_end_copy() syncs the PostgreSQL frontend (usually a web
server process) with the PostgreSQL server after doing a
copy operation performed by pg_put_line(). pg_end_copy()
must be issued, otherwise the PostgreSQL server may get
out of sync with the frontend and will report an error.
Returns TRUE on success or FALSE on failure.
For further details and an example, see also pg_put_line().
pg_escape_bytea
(PHP 4 >= 4.2.0)
pg_escape_bytea -- Escape binary for bytea type
Description
string pg_escape_bytea ( string data)
pg_escape_bytea() escapes string for bytea datatype. It
returns escaped string.
Note: When you SELECT bytea type, PostgreSQL returns octal
byte value prefixed by \ (e.g. \032). Users are supposed
to convert back to binary format by yourself.
This function requires PostgreSQL 7.2 or later. With PostgreSQL
7.2.0 and 7.2.1, bytea type must be casted when you enable
multi-byte support. i.e. INSERT INTO test_table (image)
VALUES ('$image_escaped'::bytea); PostgreSQL 7.2.2 or later
does not need cast. Exception is when client and backend
character encoding does not match, there may be multi-byte
stream error. User must cast to bytea to avoid this error.
See also pg_unescape_bytea() and pg_escape_string().
|