pg_put_line

pg_put_line

Send a NULL-terminated string to PostgreSQL backend

bool **pg_put_line** PgSql\Connection $connection string $data

sends a NULL-terminated string

to the PostgreSQL backend server. This is needed in conjunction with PostgreSQL's command. pg_put_line``COPY FROM

is a high-speed data loading interface supported by PostgreSQL. Data is passed in without being parsed, and in a single transaction. COPY

An alternative to using raw commands is to use . This is a far simpler interface. pg_put_line``pg_copy_from

Opmerking: > The application must explicitly send the two characters "." on the last line to indicate to the backend that it has finished sending its data, before issuing . pg_end_copy

Waarschuwing: > Use of the causes most large object operations, including and , to subsequently fail. You can use and instead. pg_put_line``pg_lo_read``pg_lo_tell``pg_copy_from``pg_copy_to

connection``data A line of text to be sent directly to the PostgreSQL backend. A terminator is added automatically. NULL

return.success

Voorbeeld: 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);
?>

pg_end_copy