Home
last modified time | relevance | path

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

12

/PHP-5.6/ext/pgsql/tests/
H A Dpg_select_001.phpt12 pg_query('CREATE SCHEMA phptests');
14 pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
15 pg_query('INSERT INTO phptests.foo VALUES (1,2)');
16 pg_query('INSERT INTO phptests.foo VALUES (2,3)');
18 pg_query('CREATE TABLE phptests.bar (id4 INT, id3 INT)');
19 pg_query('INSERT INTO phptests.bar VALUES (4,5)');
20 pg_query('INSERT INTO phptests.bar VALUES (6,7)');
35 pg_query('DROP TABLE phptests.foo');
36 pg_query('DROP TABLE phptests.bar');
37 pg_query('DROP SCHEMA phptests');
H A Dbug37100.phpt14 @pg_query("SET bytea_output = 'escape'");
16 @pg_query('DROP TABLE test_bug');
18 pg_query('CREATE TABLE test_bug (binfield byteA) ;');
19 pg_query("INSERT INTO test_bug VALUES (decode('0103AA000812','hex'))");
22 $data = pg_query("SELECT binfield FROM test_bug");
29 $data = pg_query($sql);
38 pg_query('DROP TABLE test_bug');
H A D01createdb.phpt12 if (!@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name)))
14 pg_query($db,$table_def); // Create table here
16 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');");
24 if (version_compare($v['server'], '9.2', '>=') && !@pg_num_rows(@pg_query($db, "SELECT * FROM ".$ta…
26 pg_query($db,$table_def_92); // Create table here
33 pg_query($db,$view_def);
H A Dbug37100_9.phpt15 @pg_query('DROP TABLE test_bug');
17 pg_query('CREATE TABLE test_bug (binfield byteA) ;');
18 pg_query("INSERT INTO test_bug VALUES (decode('0103AA000812','hex'))");
21 $data = pg_query("SELECT binfield FROM test_bug");
28 $data = pg_query($sql);
37 pg_query('DROP TABLE test_bug');
H A Dpg_update_001.phpt12 pg_query('CREATE SCHEMA phptests');
14 pg_query('CREATE TABLE foo (id INT, id2 INT)');
15 pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
27 $rs = pg_query('SELECT * FROM foo UNION SELECT * FROM phptests.foo');
32 pg_query('DROP TABLE foo');
33 pg_query('DROP TABLE phptests.foo');
34 pg_query('DROP SCHEMA phptests');
H A Dbug64609.phpt15 pg_query("BEGIN");
16 pg_query("CREATE TYPE t_enum AS ENUM ('ok', 'ko')");
17 pg_query("CREATE TABLE test_enum (a t_enum)");
22 pg_query("ROLLBACK");
H A D80_bug24499.phpt17 @pg_query("DROP SEQUENCE id_id_seq");
18 @pg_query("DROP TABLE id");
19 pg_query("CREATE TABLE id (id SERIAL, t INT)");
22 pg_query("INSERT INTO id (t) VALUES ($i)");
33 $q = pg_query($dbh, "SELECT id FROM id");
H A Dpg_delete_001.phpt12 pg_query('CREATE SCHEMA phptests');
14 pg_query('CREATE TABLE foo (id INT, id2 INT)');
15 pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
35 var_dump(pg_fetch_all(pg_query('SELECT * FROM foo')));
36 var_dump(pg_fetch_all(pg_query('SELECT * FROM phptests.foo')));
42 pg_query('DROP TABLE foo');
43 pg_query('DROP TABLE phptests.foo');
44 pg_query('DROP SCHEMA phptests');
H A D9999dropdb.phpt12 pg_query($db, "DROP VIEW {$view_name}");
13 pg_query($db, "DROP TABLE ".$table_name);
14 @pg_query($db, "DROP TABLE ".$table_name_92);
H A D09notice.phpt23 $res = pg_query($db, 'SET client_min_messages TO NOTICE;');
26 pg_query($db, "BEGIN;");
27 pg_query($db, "BEGIN;");
41 Notice: pg_query(): %s already a transaction in progress in %s on line %d
H A Dbug47199.phpt14 @pg_query("DROP TABLE $tbl_name");
15 pg_query("CREATE TABLE $tbl_name (null_field INT, not_null_field INT NOT NULL)");
20 var_dump(pg_fetch_all(pg_query('SELECT * FROM '. $tbl_name)));
30 var_dump(pg_fetch_all(pg_query('SELECT * FROM '. $tbl_name)));
32 @pg_query("DROP TABLE $tbl_name");
H A D80_bug32223.phpt9 @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'");
10 $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
33 $res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
40 $res = pg_query($dbh, 'SET client_min_messages TO NOTICE;');
42 $res = pg_query($dbh, 'SELECT test_notice()');
H A D80_bug32223b.phpt9 @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'");
10 $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
33 $res = pg_query(dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
40 $res = pg_query(dbh, 'SET client_min_messages TO NOTICE;');
44 $res = pg_query(dbh, 'SELECT test_notice()');
H A Dpg_insert_001.phpt12 pg_query('CREATE SCHEMA phptests');
13 pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
24 pg_query('DROP TABLE phptests.foo');
25 pg_query('DROP SCHEMA phptests');
H A D80_bug27597.phpt17 @pg_query("DROP TABLE id");
18 pg_query("CREATE TABLE id (id INT)");
21 pg_query("INSERT INTO id (id) VALUES ($i)");
29 $res = pg_query("SELECT * FROM id");
H A Dbug65119.phpt13 pg_query("begin");
14 pg_query("CREATE TABLE bug65119 (i INTEGER)");
16 pg_query("rollback");
H A Dpg_meta_data_001.phpt12 pg_query('CREATE SCHEMA phptests');
14 pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
16 pg_query('CREATE TABLE foo (id INT, id3 INT)');
24 pg_query('DROP TABLE foo');
25 pg_query('DROP TABLE phptests.foo');
26 pg_query('DROP SCHEMA phptests');
H A D18pg_escape_bytea_before.phpt15 @pg_query($db, "SET bytea_output = 'escape'");
17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');');
18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_hex.phpt15 @pg_query($db, "SET bytea_output = 'hex'");
20 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
21 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_esc.phpt12 @pg_query($db, "SET bytea_output = 'escape'");
17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D80_bug42783.phpt17 pg_query("CREATE TABLE php_test (id SERIAL PRIMARY KEY, time TIMESTAMP NOT NULL DEFAULT now())");
21 var_dump(pg_fetch_assoc(pg_query("SELECT * FROM php_test")));
23 pg_query($dbh, "DROP TABLE php_test");
H A D03sync_query.phpt12 $result = pg_query($db, "SELECT * FROM ".$table_name.";");
55 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
56 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
64 $result = pg_query($db, "INSERT INTO ".$table_name." VALUES (9999, 'ABC');");
H A D21pg_get_notify.phpt12 pg_query($db, 'LISTEN test_msg');
13 pg_query($db, 'NOTIFY test_msg');
H A D08escape.phpt46 pg_query("DELETE FROM ".$table_name." WHERE num = -9999;");
48 pg_query($db, $sql);
53 $result = pg_query($db, $sql);
62 @pg_query($db, "SET bytea_output = 'escape'");
65 $result = pg_query($db, $sql);
/PHP-5.6/ext/pgsql/
H A Dmysql_users.php31 return pg_query($db, $query);
53 return pg_query($db, $query);
79 return pg_query($db, $query);

Completed in 25 milliseconds

12