/dports/databases/zabbix3-libzbxpgsql/libzbxpgsql-1.1.0/src/ |
H A D | pg_database.c | 100 char *datname = NULL; in PG_STAT_DATABASE() local 111 datname = get_rparam(request, PARAM_FIRST); in PG_STAT_DATABASE() 112 if(strisnull(datname)) { in PG_STAT_DATABASE() 115 datname = NULL; // ensure datname is NULL, not '\0' in PG_STAT_DATABASE() 123 if(strisnull(datname)) { in PG_STAT_DATABASE() 198 char *datname = NULL; in PG_DB_SIZE() local 204 datname = get_rparam(request, PARAM_FIRST); in PG_DB_SIZE() 205 if (strisnull(datname)) { in PG_DB_SIZE() 240 char *datname = NULL; in PG_DB_XID_AGE() local 245 datname = get_rparam(request, PARAM_FIRST); in PG_DB_XID_AGE() [all …]
|
H A D | pg_server.c | 163 char *datname = NULL; in PG_PREPARED_XACTS_COUNT() local 168 datname = get_rparam(request, PARAM_FIRST); in PG_PREPARED_XACTS_COUNT() 169 if(strisnull(datname)) { in PG_PREPARED_XACTS_COUNT() 172 …ult, "SELECT COUNT (transaction) FROM pg_prepared_xacts WHERE database = $1;", param_new(datname)); in PG_PREPARED_XACTS_COUNT() 234 char *datname = NULL; in PG_PREPARED_XACTS_AGE() local 239 datname = get_rparam(request, PARAM_FIRST); in PG_PREPARED_XACTS_AGE() 240 if(strisnull(datname)) { in PG_PREPARED_XACTS_AGE() 259 param_new(datname) in PG_PREPARED_XACTS_AGE()
|
/dports/sysutils/munin-contrib/contrib-c31cb28/plugins/postgresql/ |
H A D | pg__connections | 79 my ($datname, $curr_conn) = (m/(\w+).*?(\d+(?:\.\d+)?)/); 81 print "$datname.label $datname active connections\n"; 82 print "$datname.info $datname active connections\n"; 83 print "$datname.type GAUGE\n"; 85 print "$datname.draw AREA\n"; 88 print "$datname.draw STACK\n"; 111 my ($datname, $curr_conn) = (m/(\w+).*?(\d+(?:\.\d+)?)/); 112 print "$datname.value $curr_conn\n";
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | alter_database_owner.sql | 18 WHERE d.datname = current_database(); 32 WHERE d.datname = current_database(); 40 WHERE d.datname = current_database(); 55 WHERE d.datname = current_database(); 71 WHERE d.datname = current_database(); 83 WHERE d.datname = current_database(); 89 WHERE d.datname = current_database(); 106 WHERE d.datname = current_database(); 126 WHERE d.datname = current_database(); 144 WHERE d.datname = current_database(); [all …]
|
H A D | columnar_drop.sql | 16 SELECT oid postgres_oid FROM pg_database WHERE datname = 'postgres' \gset 36 SELECT current_database() datname \gset 41 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() \gset 49 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() \gset 53 \c :datname
|
/dports/sysutils/munin-contrib/contrib-c31cb28/plugins/oracle/ |
H A D | oracle__tablespace_usage | 91 while ( my ($datname) = $sth_curr->fetchrow_array ) { 92 print "$datname.label $datname\n"; 93 print "$datname.info $datname tablespace\n"; 94 print "$datname.type GAUGE\n"; 95 print "$datname.draw LINE2\n"; 110 while ( my ($datname,$free,$total,$prc) = $sth_curr->fetchrow_array ) { 112 print "$datname.value $in_use\n";
|
H A D | oracle__connections | 98 while ( my ($datname,$curr_conn) = $sth->fetchrow_array ) { 99 print "$datname.label $datname active connections\n"; 100 print "$datname.info $datname active connections\n"; 101 print "$datname.type GAUGE\n"; 103 print "$datname.draw AREA\n"; 106 print "$datname.draw STACK\n"; 139 while ( my ($datname,$curr_conn) = $sth->fetchrow_array ) { 140 print "$datname.value $curr_conn\n";
|
/dports/math/gretl/gretl-2021d/tests/nist-nls/ |
H A D | nist-nls-test.c | 30 char datname[32]; member 216 if (!strcmp(tester.datname, "Misra1a")) { in print_derivs() 227 !strcmp(tester.datname, "Thurber")) { in print_derivs() 310 tester.datname, what); in missing() 336 printf("Identified %s\n", tester.datname); in get_id() 466 tester.datname, tester.nobs, n); in read_data() 505 tester.datname, MAXCOEFF); in read_params() 552 strcpy(tester.datname, "No data"); in tester_init() 666 tester.datname, round, line); in generate_params() 771 if (strcmp(tester.datname, "Lanczos1")) { in estimates_ok() [all …]
|
/dports/databases/postgresql-cstore_fdw/cstore_fdw-1.7.0/sql/ |
H A D | drop.sql | 16 SELECT oid postgres_oid FROM pg_database WHERE datname = 'postgres' \gset 22 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() 38 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() 41 SELECT current_database() datname \gset 47 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() \gset 64 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() \gset 71 \c :datname
|
/dports/databases/timescaledb/timescaledb-2.5.1/test/sql/include/ |
H A D | bgw_launcher_utils.sql | 12 count(*) filter (WHERE application_name = 'TimescaleDB Background Worker Scheduler' AND datname = :… 13 count(*) filter (WHERE application_name = 'TimescaleDB Background Worker Scheduler' AND datname = :… 14 count(*) filter (WHERE application_name = 'TimescaleDB Background Worker Scheduler' AND datname = '… 38 CREATE FUNCTION wait_for_bgw_scheduler(_datname NAME, _count INT DEFAULT 1, _ticks INT DEFAULT 10) … 49 datname = _datname
|
/dports/math/concorde/concorde/UTIL/ |
H A D | getdata.c | 865 perror (datname); in CCutil_gettsplib() 2720 if (!datname) { in read_crystal() 3182 perror (datname); in read_d2_text() 3246 perror (datname); in write_d2_text() 3382 perror (datname); in read_d3_text() 3419 perror (datname); in write_d3_text() 3537 perror (datname); in read_matrix_text() 3574 perror (datname); in write_matrix_text() 3709 perror (datname); in write_sparse_text() 3849 perror (datname); in read_user_text() [all …]
|
/dports/sysutils/ansible/ansible-4.7.0/ansible_collections/community/postgresql/tests/integration/targets/postgresql_db/tasks/ |
H A D | postgresql_db_initial.yml | 23 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres 62 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres 91 # - shell: echo "select datname from pg_database where datname = 'silly.""name';" | psql 99 # - shell: echo "select datname from pg_database where datname = 'silly.""name';" | psql 130 …shell: echo "select datname, datconnlimit, pg_encoding_to_char(encoding), datcollate, datctype fro… 202 …shell: echo "SELECT datconnlimit AS conn_limit FROM pg_database WHERE datname = '{{ db_name }}';" … 218 - shell: echo "select datname, pg_encoding_to_char(encoding), datcollate, datctype from pg_database… 266 WHERE datname = '{{ db_name }}' 297 WHERE datname = '{{ db_name }}' 323 …shell: echo "select pg_catalog.pg_get_userbyid(datdba) from pg_catalog.pg_database where datname =… [all …]
|
/dports/databases/timescaledb/timescaledb-2.5.1/test/sql/ |
H A D | bgw_launcher.sql | 37 AND datname = :'TEST_DBNAME_2' \gset 47 AND datname = :'TEST_DBNAME_2'; 54 AND datname = :'TEST_DBNAME_2'; 72 AND datname = :'TEST_DBNAME_2' \gset 89 AND datname = $2 into r; 113 AND datname = :'TEST_DBNAME_2' \gset 130 AND datname = $2 into r; 147 AND datname = :'TEST_DBNAME_2' \gset
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
H A D | isolation_citus_dist_activity.out | 35 …istributed_query_host_port, state, wait_event_type, wait_event, usename, datname FROM citus_dist_s… 37 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname 45 …istributed_query_host_port, state, wait_event_type, wait_event, usename, datname FROM citus_worker… 47 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname 105 …istributed_query_host_port, state, wait_event_type, wait_event, usename, datname FROM citus_dist_s… 107 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname 117 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname 171 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname 181 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname 238 …st_name|distributed_query_host_port|state |wait_event_type|wait_event|usename |datname [all …]
|
H A D | alter_database_owner.out | 31 WHERE d.datname = current_database(); 53 WHERE d.datname = current_database(); 65 WHERE d.datname = current_database(); 87 WHERE d.datname = current_database(); 116 WHERE d.datname = current_database(); 133 WHERE d.datname = current_database(); 144 WHERE d.datname = current_database(); 177 WHERE d.datname = current_database(); 211 WHERE d.datname = current_database(); 238 WHERE d.datname = current_database(); [all …]
|
/dports/databases/pg_stat_kcache/pg_stat_kcache-REL2_2_0/test/sql/ |
H A D | pgsk.sql | 7 SELECT count(*) FROM pg_stat_kcache WHERE datname = current_database(); 9 SELECT count(*) FROM pg_stat_kcache_detail WHERE datname = current_database() AND (query = 'SELECT … 13 WHERE datname = current_database() 24 WHERE datname = current_database()
|
/dports/databases/postgresql-cstore_fdw/cstore_fdw-1.7.0/expected/ |
H A D | drop.out | 14 SELECT oid postgres_oid FROM pg_database WHERE datname = 'postgres' \gset 19 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() 38 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() 45 SELECT current_database() datname \gset 50 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() \gset 80 SELECT oid::text databaseoid FROM pg_database WHERE datname = current_database() \gset 89 \c :datname
|
/dports/sysutils/ansible2/ansible-2.9.27/test/integration/targets/postgresql/tasks/ |
H A D | unsorted.yml | 22 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres 60 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres 89 # - shell: echo "select datname from pg_database where datname = 'silly.""name';" | psql 97 # - shell: echo "select datname from pg_database where datname = 'silly.""name';" | psql 122 …shell: echo "select datname, datconnlimit, pg_encoding_to_char(encoding), datcollate, datctype fro… 209 - shell: echo "select datname, pg_encoding_to_char(encoding), datcollate, datctype from pg_database… 327 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres 404 shell: echo "select datacl from pg_database where datname='{{ db_name }}';" | psql {{ db_name }} 650 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres 702 shell: echo "select datname from pg_database where datname = '{{ db_name }}';" | psql -d postgres [all …]
|
/dports/databases/timescaledb/timescaledb-2.5.1/test/src/ |
H A D | test_utils.c | 82 text *datname = PG_GETARG_TEXT_PP(0); in ts_bgw_wait() local 86 Oid dboid = get_database_oid(text_to_cstring(datname), false); in ts_bgw_wait() 98 text_to_cstring(datname)), in ts_bgw_wait() 107 text_to_cstring(datname)), in ts_bgw_wait()
|
/dports/databases/pg_activity/pg_activity-2.2.0/pgactivity/queries/ |
H A D | get_db_info.sql | 7 ELSE SUM(pg_database_size(datname)) 9 MAX(LENGTH(datname)) AS max_length 11 WHERE NOT (datname = 'rdsadmin' AND %(using_rds)s);
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/bin/pg_amcheck/ |
H A D | pg_amcheck.c | 148 char *datname; member 554 cparams.override_dbname = dat->datname; in main() 717 latest_datname = rel->datinfo->datname; in main() 1224 const char *datname, bool force, bool finished) in progress_report() argument 1260 if (!datname) in progress_report() 1288 truncate ? datname + strlen(datname) - VERBOSE_DATNAME_LENGTH + 3 : datname); in progress_report() 1564 dat->datname = pstrdup(initial_dbname); in compile_database_list() 1668 const char *datname = NULL; in compile_database_list() local 1673 datname = PQgetvalue(res, i, 1); in compile_database_list() 1696 Assert(datname != NULL); in compile_database_list() [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/bin/pg_amcheck/ |
H A D | pg_amcheck.c | 148 char *datname; member 554 cparams.override_dbname = dat->datname; in main() 717 latest_datname = rel->datinfo->datname; in main() 1224 const char *datname, bool force, bool finished) in progress_report() argument 1260 if (!datname) in progress_report() 1288 truncate ? datname + strlen(datname) - VERBOSE_DATNAME_LENGTH + 3 : datname); in progress_report() 1564 dat->datname = pstrdup(initial_dbname); in compile_database_list() 1668 const char *datname = NULL; in compile_database_list() local 1673 datname = PQgetvalue(res, i, 1); in compile_database_list() 1696 Assert(datname != NULL); in compile_database_list() [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/bin/pg_amcheck/ |
H A D | pg_amcheck.c | 148 char *datname; member 554 cparams.override_dbname = dat->datname; in main() 717 latest_datname = rel->datinfo->datname; in main() 1224 const char *datname, bool force, bool finished) in progress_report() argument 1260 if (!datname) in progress_report() 1288 truncate ? datname + strlen(datname) - VERBOSE_DATNAME_LENGTH + 3 : datname); in progress_report() 1564 dat->datname = pstrdup(initial_dbname); in compile_database_list() 1668 const char *datname = NULL; in compile_database_list() local 1673 datname = PQgetvalue(res, i, 1); in compile_database_list() 1696 Assert(datname != NULL); in compile_database_list() [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/bin/pg_amcheck/ |
H A D | pg_amcheck.c | 148 char *datname; member 554 cparams.override_dbname = dat->datname; in main() 717 latest_datname = rel->datinfo->datname; in main() 1224 const char *datname, bool force, bool finished) in progress_report() argument 1260 if (!datname) in progress_report() 1288 truncate ? datname + strlen(datname) - VERBOSE_DATNAME_LENGTH + 3 : datname); in progress_report() 1564 dat->datname = pstrdup(initial_dbname); in compile_database_list() 1668 const char *datname = NULL; in compile_database_list() local 1673 datname = PQgetvalue(res, i, 1); in compile_database_list() 1696 Assert(datname != NULL); in compile_database_list() [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/bin/pg_amcheck/ |
H A D | pg_amcheck.c | 148 char *datname; member 554 cparams.override_dbname = dat->datname; in main() 717 latest_datname = rel->datinfo->datname; in main() 1224 const char *datname, bool force, bool finished) in progress_report() argument 1260 if (!datname) in progress_report() 1288 truncate ? datname + strlen(datname) - VERBOSE_DATNAME_LENGTH + 3 : datname); in progress_report() 1564 dat->datname = pstrdup(initial_dbname); in compile_database_list() 1668 const char *datname = NULL; in compile_database_list() local 1673 datname = PQgetvalue(res, i, 1); in compile_database_list() 1696 Assert(datname != NULL); in compile_database_list() [all …]
|