Home
last modified time | relevance | path

Searched refs:pg_query (Results 1 – 25 of 55) sorted by relevance

123

/PHP-8.1/ext/pgsql/tests/
H A Dpg_select_001.phpt14 pg_query($conn, 'CREATE SCHEMA phptests');
16 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)');
17 pg_query($conn, 'INSERT INTO phptests.foo VALUES (1,2)');
18 pg_query($conn, 'INSERT INTO phptests.foo VALUES (2,3)');
20 pg_query($conn, 'CREATE TABLE phptests.bar (id4 INT, id3 INT)');
21 pg_query($conn, 'INSERT INTO phptests.bar VALUES (4,5)');
22 pg_query($conn, 'INSERT INTO phptests.bar VALUES (6,7)');
39 pg_query($conn, 'DROP TABLE phptests.foo');
40 pg_query($conn, 'DROP TABLE phptests.bar');
41 pg_query($conn, 'DROP SCHEMA phptests');
H A Dbug37100.phpt16 @pg_query("SET bytea_output = 'escape'");
18 @pg_query('DROP TABLE test_bug');
20 pg_query('CREATE TABLE test_bug (binfield byteA) ;');
21 pg_query("INSERT INTO test_bug VALUES (decode('0103AA000812','hex'))");
24 $data = pg_query("SELECT binfield FROM test_bug");
31 $data = pg_query($sql);
40 pg_query('DROP TABLE test_bug');
H A D01createdb.phpt14 if (!($q = @pg_query($db, "SELECT * FROM ".$table_name)) || !@pg_num_rows($q))
16 pg_query($db,$table_def); // Create table here
18 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');");
26 if (version_compare($v['server'], '9.2', '>=') && (!($q = @pg_query($db, "SELECT * FROM ".$table_na…
28 pg_query($db,$table_def_92); // Create table here
35 pg_query($db,$view_def);
H A Dbug37100_9.phpt17 @pg_query($db, 'DROP TABLE test_bug');
19 pg_query($db, 'CREATE TABLE test_bug (binfield byteA) ;');
20 pg_query($db, "INSERT INTO test_bug VALUES (decode('0103AA000812','hex'))");
23 $data = pg_query($db, "SELECT binfield FROM test_bug");
30 $data = pg_query($db, $sql);
39 pg_query($db, 'DROP TABLE test_bug');
H A Dpg_update_001.phpt14 pg_query($conn, 'CREATE SCHEMA phptests');
16 pg_query($conn, 'CREATE TABLE foo (id INT, id2 INT)');
17 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)');
29 $rs = pg_query($conn, 'SELECT * FROM foo UNION SELECT * FROM phptests.foo ORDER BY id');
34 pg_query($conn, 'DROP TABLE foo');
35 pg_query($conn, 'DROP TABLE phptests.foo');
36 pg_query($conn, 'DROP SCHEMA phptests');
H A D09notice.phpt25 $res = pg_query($db, 'SET client_min_messages TO NOTICE;');
32 pg_query($db, "BEGIN;");
33 pg_query($db, "BEGIN;");
34 pg_query($db, "BEGIN;");
35 pg_query($db, "BEGIN;");
60 Notice: pg_query(): %s already a transaction in progress in %s on line %d
62 Notice: pg_query(): %s already a transaction in progress in %s on line %d
64 Notice: pg_query(): %s already a transaction in progress in %s on line %d
H A Dbug64609.phpt17 pg_query($db, "BEGIN");
18 pg_query($db, "CREATE TYPE t_enum AS ENUM ('ok', 'ko')");
19 pg_query($db, "CREATE TABLE test_enum (a t_enum)");
24 pg_query($db, "ROLLBACK");
H A D06copy_2.phpt14 pg_query($db, 'CREATE TABLE test_copy (x int)');
16 pg_query($db, 'COPY test_copy FROM STDIN');
23 var_dump(pg_fetch_all_columns(pg_query($db, 'SELECT * FROM test_copy ORDER BY 1')));
25 pg_query($db, 'DROP TABLE test_copy');
H A D80_bug24499.phpt19 @pg_query($dbh, "DROP SEQUENCE id_id_seq");
20 @pg_query($dbh, "DROP TABLE id");
21 pg_query($dbh, "CREATE TABLE id (id SERIAL, t INT)");
24 pg_query($dbh, "INSERT INTO id (t) VALUES ($i)");
35 $q = pg_query($dbh, "SELECT id FROM id");
H A Dpg_delete_001.phpt14 pg_query($conn, 'CREATE SCHEMA phptests');
16 pg_query($conn, 'CREATE TABLE foo (id INT, id2 INT)');
17 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)');
37 var_dump(pg_fetch_all(pg_query($conn, 'SELECT * FROM foo')));
38 var_dump(pg_fetch_all(pg_query($conn, 'SELECT * FROM phptests.foo')));
44 pg_query($conn, 'DROP TABLE foo');
45 pg_query($conn, 'DROP TABLE phptests.foo');
46 pg_query($conn, 'DROP SCHEMA phptests');
H A D9999dropdb.phpt14 pg_query($db, "DROP VIEW {$view_name}");
15 pg_query($db, "DROP TABLE ".$table_name);
16 @pg_query($db, "DROP TABLE ".$table_name_92);
H A D80_bug32223b.phpt11 @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'");
12 $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
35 $res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
42 $res = pg_query($dbh, 'SET client_min_messages TO NOTICE;');
46 $res = pg_query($dbh, 'SELECT test_notice()');
H A D80_bug32223.phpt11 @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'");
12 $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
35 $res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
42 $res = pg_query($dbh, 'SET client_min_messages TO NOTICE;');
44 $res = pg_query($dbh, 'SELECT test_notice()');
H A D80_bug27597.phpt19 @pg_query($dbh, "DROP TABLE id");
20 pg_query($dbh, "CREATE TABLE id (id INT)");
23 pg_query($dbh, "INSERT INTO id (id) VALUES ($i)");
31 $res = pg_query($dbh, "SELECT * FROM id");
H A Dbug47199.phpt16 @pg_query($dbh, "DROP TABLE $tbl_name");
17 pg_query($dbh, "CREATE TABLE $tbl_name (null_field INT, not_null_field INT NOT NULL)");
22 var_dump(pg_fetch_all(pg_query($dbh, 'SELECT * FROM '. $tbl_name)));
32 var_dump(pg_fetch_all(pg_query($dbh, 'SELECT * FROM '. $tbl_name)));
34 @pg_query($dbh, "DROP TABLE $tbl_name");
H A Dpg_insert_001.phpt14 pg_query($conn, 'CREATE SCHEMA phptests');
15 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)');
26 pg_query($conn, 'DROP TABLE phptests.foo');
27 pg_query($conn, 'DROP SCHEMA phptests');
H A Dgh8253.phpt18 pg_query($db, "DROP TABLE IF EXISTS gh8253");
19 pg_query($db, "CREATE TABLE gh8253 (bar text);");
21 $res = pg_query($db, "SELECT * FROM gh8253");
H A Dbug65119.phpt15 pg_query($connection, "begin");
16 pg_query($connection, "CREATE TABLE bug65119 (i INTEGER)");
18 pg_query($connection, "rollback");
H A D18pg_escape_bytea_esc.phpt14 @pg_query($db, "SET bytea_output = 'escape'");
19 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
20 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_hex.phpt17 @pg_query($db, "SET bytea_output = 'hex'");
22 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
23 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D80_bug42783.phpt19 pg_query($dbh, "CREATE TABLE php_test (id SERIAL PRIMARY KEY, time TIMESTAMP NOT NULL DEFAULT now()…
23 var_dump(pg_fetch_assoc(pg_query($dbh, "SELECT * FROM php_test")));
25 pg_query($dbh, "DROP TABLE php_test");
H A Dpg_meta_data_001.phpt14 pg_query($conn, 'CREATE SCHEMA phptests');
16 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)');
18 pg_query($conn, 'CREATE TABLE foo (id INT, id3 INT)');
26 pg_query($conn, 'DROP TABLE foo');
27 pg_query($conn, 'DROP TABLE phptests.foo');
28 pg_query($conn, 'DROP SCHEMA phptests');
H A D18pg_escape_bytea_before.phpt17 @pg_query($db, "SET bytea_output = 'escape'");
19 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');');
20 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A Dgh10672.phpt16 pg_query($db, "DROP TABLE IF EXISTS gh10672");
17 pg_query($db, "CREATE TABLE gh10672 (bar text);");
20 pg_query($db, 'BEGIN');
H A D21pg_get_notify.phpt14 pg_query($db, 'LISTEN test_msg');
15 pg_query($db, 'NOTIFY test_msg');

Completed in 18 milliseconds

123