06copy_2.phpt 562 B

12345678910111213141516171819202122232425262728293031323334
  1. --TEST--
  2. PostgreSQL copy functions, part 2
  3. --EXTENSIONS--
  4. pgsql
  5. --SKIPIF--
  6. <?php include("skipif.inc"); ?>
  7. --FILE--
  8. <?php
  9. include('config.inc');
  10. $db = pg_connect($conn_str);
  11. pg_query($db, 'CREATE TABLE test_copy (x int)');
  12. pg_query($db, 'COPY test_copy FROM STDIN');
  13. pg_put_line($db, "1\n");
  14. pg_put_line($db, "\\N\n");
  15. pg_put_line($db, "\\.\n");
  16. pg_end_copy($db);
  17. var_dump(pg_fetch_all_columns(pg_query($db, 'SELECT * FROM test_copy ORDER BY 1')));
  18. pg_query($db, 'DROP TABLE test_copy');
  19. ?>
  20. --EXPECT--
  21. array(2) {
  22. [0]=>
  23. string(1) "1"
  24. [1]=>
  25. NULL
  26. }