Home
last modified time | relevance | path

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

123

/PHP-8.0/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)');
37 pg_query('DROP TABLE phptests.foo');
38 pg_query('DROP TABLE phptests.bar');
39 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 (!($q = @pg_query($db, "SELECT * FROM ".$table_name)) || !@pg_num_rows($q))
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', '>=') && (!($q = @pg_query($db, "SELECT * FROM ".$table_na…
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 ORDER BY id');
32 pg_query('DROP TABLE foo');
33 pg_query('DROP TABLE phptests.foo');
34 pg_query('DROP SCHEMA phptests');
H A D09notice.phpt23 $res = pg_query($db, 'SET client_min_messages TO NOTICE;');
30 pg_query($db, "BEGIN;");
31 pg_query($db, "BEGIN;");
32 pg_query($db, "BEGIN;");
33 pg_query($db, "BEGIN;");
57 Notice: pg_query(): %s already a transaction in progress in %s on line %d
59 Notice: pg_query(): %s already a transaction in progress in %s on line %d
61 Notice: pg_query(): %s already a transaction in progress in %s on line %d
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 D06copy_2.phpt12 pg_query($db, 'CREATE TABLE test_copy (x int)');
14 pg_query($db, 'COPY test_copy FROM STDIN');
21 var_dump(pg_fetch_all_columns(pg_query($db, 'SELECT * FROM test_copy ORDER BY 1')));
23 pg_query($db, 'DROP TABLE test_copy');
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 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 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 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 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 Dbug65119.phpt13 pg_query("begin");
14 pg_query("CREATE TABLE bug65119 (i INTEGER)");
16 pg_query("rollback");
H A Dgh8253.phpt16 pg_query($db, "DROP TABLE IF EXISTS gh8253");
17 pg_query($db, "CREATE TABLE gh8253 (bar text);");
19 $res = pg_query($db, "SELECT * FROM gh8253");
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_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 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 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 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 D21pg_get_notify.phpt12 pg_query($db, 'LISTEN test_msg');
13 pg_query($db, 'NOTIFY test_msg');
H A Dbug72028.phpt15 pg_query("CREATE TABLE $table (value TEXT, details TEXT);");
30 $r = pg_query("SELECT * FROM $table");
35 pg_query("DROP TABLE $table");

Completed in 19 milliseconds

123