Lines Matching refs:conn
14 $conn = pg_connect($conn_str);
16 pg_query($conn, "CREATE SCHEMA {$schema_name}");
18 pg_query($conn, "CREATE TABLE {$table_name} (id INT, id2 INT)");
19 pg_query($conn, "CREATE TABLE {$schema_name}.{$table_name} (id INT, id2 INT)");
22 pg_insert($conn, $table_name, array('id' => 1, 'id2' => 1));
23 pg_insert($conn, "{$schema_name}.{$table_name}", array('id' => 1, 'id2' => 2));
25 pg_update($conn, $table_name, array('id' => 10), array('id' => 1));
26 var_dump(pg_update($conn, $table_name, array('id' => 10), array('id' => 1), PGSQL_DML_STRING));
28 pg_update($conn, "{$schema_name}.{$table_name}", array('id' => 100), array('id2' => 2));
29 var_dump(pg_update($conn, "{$schema_name}.{$table_name}", array('id' => 100), array('id2' => 2), PG…
31 $rs = pg_query($conn, "SELECT * FROM {$table_name} UNION SELECT * FROM {$schema_name}.{$table_name}…
43 $conn = pg_connect($conn_str);
45 pg_query($conn, "DROP TABLE IF EXISTS {$table_name}");
46 pg_query($conn, "DROP TABLE IF EXISTS {$schema_name}.{$table_name}");
47 pg_query($conn, "DROP SCHEMA IF EXISTS {$schema_name}");
