Warning
Use of the
pg_put_line()
causes most large object
operations, including
pg_lo_read()
and
pg_lo_tell()
, to subsequently fail. You can use
pg_copy_from()
and
pg_copy_to()
instead.
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.
A line of text to be sent directly to the PostgreSQL backend. A
NULL
terminator is added automatically.
Example #1
pg_put_line()
example
<?php
$conn
=
pg_pconnect
(
"dbname=foo"
);
pg_query
(
$conn
,
"create table bar (a int4, b char(16), d float8)"
);
pg_query
(
$conn
,
"copy bar from stdin"
);
pg_put_line
(
$conn
,
"3\thello world\t4.5\n"
);
pg_put_line
(
$conn
,
"4\tgoodbye world\t7.11\n"
);
pg_put_line
(
$conn
,
"\\.\n"
);
pg_end_copy
(
$conn
);
?>
smcbride at msn dot com
¶
5 years ago
When using this function, don't get bit by using 'literal\tanotherliteral\n' issue by using single quotes vs. double quotes. "literal\tanotherliteral\n" is not the same. Many of the functions are impacted on how double quotes treats escape characters different than single quotes. I forget it all the time.
