1<?php 2 3// These vars are used to connect db and create test table. 4// values can be set to meet your environment with the 5// environment var PGSQL_TEST_CONNSTR 6 7// "test" database must exist. i.e. "createdb test" before testing 8$conn_str = getenv('PGSQL_TEST_CONNSTR') ?: "host=localhost dbname=test port=5432 user=postgres password=postgres"; // connection string 9 10$table_name = "php_pgsql_test"; // test table that will be created 11$table_name_92 = "php_pgsql_test_92"; // test table that will be created 12$num_test_record = 1000; // Number of records to create 13 14// Test view 15$view_name = "php_pgsql_viewtest"; 16$view_def = "CREATE VIEW {$view_name} AS SELECT * FROM {$table_name};"; 17 18// Test table 19$table_def = "CREATE TABLE {$table_name} (num int, str text, bin bytea);"; 20$table_def_92 = "CREATE TABLE {$table_name_92} (textary text[], jsn json);"; 21$field_name = "num"; // For pg_field_num() 22 23?> 24
