tests/testthat/trade_statistics/SELECT-526b8c.R

In pointblank: Data Validation and Organization of Metadata for Local and Remote Tables

structure(list(oid = c(16L, 17L, 18L, 19L, 20L, 21L, 22L, 23L, 
24L, 25L, 26L, 27L, 28L, 29L, 30L, 71L, 75L, 81L, 83L, 114L, 
142L, 143L, 199L, 194L, 3361L, 3402L, 32L, 210L, 600L, 601L, 
602L, 603L, 604L, 628L, 629L, 700L, 701L, 702L, 703L, 704L, 705L, 
718L, 719L, 790L, 791L, 829L, 869L, 650L, 774L, 1000L, 1001L, 
1002L, 1003L, 1005L, 1006L, 1007L, 1008L, 1009L, 1028L, 1010L, 
1011L, 1012L, 1013L, 1014L, 1015L, 1016L, 1017L, 1018L, 1019L, 
1020L, 1021L, 1022L, 1023L, 1024L, 1025L, 1027L, 1033L, 1034L, 
1040L, 775L, 1041L, 651L, 1263L, 1042L, 1043L, 1082L, 1083L, 
1114L, 1115L, 1182L, 1183L, 1184L, 1185L, 1186L, 1187L, 1231L, 
1266L, 1270L, 1560L, 1561L, 1562L, 1563L, 1700L, 1790L, 2201L, 
2202L, 2203L, 2204L, 2205L, 2206L, 4096L, 4089L, 2207L, 2208L, 
2209L, 2210L, 2211L, 4097L, 4090L, 2950L, 2951L, 3220L, 3221L, 
3614L, 3642L, 3615L, 3734L, 3769L, 3643L, 3644L, 3645L, 3735L, 
3770L, 3802L, 3807L, 2970L, 2949L, 3904L, 3905L, 3906L, 3907L, 
3908L, 3909L, 3910L, 3911L, 3912L, 3913L, 3926L, 3927L, 2249L, 
2287L, 2275L, 2276L, 2277L, 2278L, 2279L, 3838L, 2280L, 2281L, 
2282L, 2283L, 2776L, 3500L, 3115L, 325L, 3310L, 3831L, 10000L, 
10001L, 10002L, 10003L, 10004L, 10005L, 10006L, 10130L, 10131L, 
10841L, 11253L, 11254L, 11255L, 11256L, 11257L, 11258L, 11259L, 
11260L, 11261L, 11262L, 11263L, 11483L, 11484L, 11485L, 11486L, 
1248L, 11487L, 11488L, 11489L, 2842L, 2843L, 11490L, 11491L, 
11492L, 11493L, 11494L, 11495L, 11496L, 11497L, 11498L, 11499L, 
11500L, 11501L, 11502L, 11503L, 11504L, 11505L, 11506L, 4066L, 
11507L, 11508L, 11509L, 11510L, 11511L, 11512L, 11513L, 6101L, 
11514L, 11515L, 11516L, 11517L, 11518L, 11519L, 11520L, 11521L, 
11522L, 11523L, 11524L, 11525L, 11526L, 11528L, 11532L, 11536L, 
11539L, 11542L, 11546L, 11550L, 11554L, 11558L, 11562L, 11566L, 
11570L, 11574L, 11578L, 11581L, 11584L, 11587L, 11590L, 11594L, 
11597L, 11601L, 11606L, 11609L, 11612L, 11615L, 11618L, 11621L, 
11625L, 11629L, 11633L, 11636L, 11640L, 11643L, 11647L, 11650L, 
11653L, 11657L, 11660L, 11663L, 11667L, 11670L, 11673L, 11677L, 
11680L, 11683L, 11687L, 11691L, 11694L, 11697L, 11700L, 11704L, 
11707L, 11710L, 11714L, 11718L, 11721L, 11724L, 11728L, 11732L, 
12741L, 12743L, 12744L, 12746L, 12748L, 12749L, 12752L, 12756L, 
12759L, 12763L, 12767L, 12771L, 12775L, 12779L, 12783L, 12787L, 
12791L, 12795L, 12799L, 12803L, 12807L, 12811L, 12814L, 12818L, 
12821L, 12825L, 12829L, 12833L, 12836L, 12840L, 12843L, 12847L, 
12850L, 12854L, 12856L, 12859L, 12861L, 12864L, 12866L, 12869L, 
12871L, 12874L, 12876L, 12879L, 12881L, 12884L, 12886L, 12889L, 
12893L, 12897L, 12900L, 12904L, 12908L, 12912L, 12916L, 12920L, 
12923L, 12927L, 12930L, 12934L, 12938L, 12942L, 12946L, 12950L, 
12954L, 12958L, 12962L, 12965L, 12968L, 12971L, 12974L, 12978L, 
12981L, 12984L, 12988L, 12991L, 12994L, 12998L, 13002L, 16504L, 
16503L, 16510L, 16522L, 16528L, 16527L, 16552L, 16551L, 16569L, 
16568L, 16589L, 16588L, 16617L, 16616L, 16637L, 16636L, 16917L, 
16916L, 16930L, 16929L, 16516L, 16943L, 16942L, 16515L, 16957L, 
16956L, 16970L, 16969L), typname = c("bool", "bytea", "char", 
"name", "int8", "int2", "int2vector", "int4", "regproc", "text", 
"oid", "tid", "xid", "cid", "oidvector", "pg_type", "pg_attribute", 
"pg_proc", "pg_class", "json", "xml", "_xml", "_json", "pg_node_tree", 
"pg_ndistinct", "pg_dependencies", "pg_ddl_command", "smgr", 
"point", "lseg", "path", "box", "polygon", "line", "_line", "float4", 
"float8", "abstime", "reltime", "tinterval", "unknown", "circle", 
"_circle", "money", "_money", "macaddr", "inet", "cidr", "macaddr8", 
"_bool", "_bytea", "_char", "_name", "_int2", "_int2vector", 
"_int4", "_regproc", "_text", "_oid", "_tid", "_xid", "_cid", 
"_oidvector", "_bpchar", "_varchar", "_int8", "_point", "_lseg", 
"_path", "_box", "_float4", "_float8", "_abstime", "_reltime", 
"_tinterval", "_polygon", "aclitem", "_aclitem", "_macaddr", 
"_macaddr8", "_inet", "_cidr", "_cstring", "bpchar", "varchar", 
"date", "time", "timestamp", "_timestamp", "_date", "_time", 
"timestamptz", "_timestamptz", "interval", "_interval", "_numeric", 
"timetz", "_timetz", "bit", "_bit", "varbit", "_varbit", "numeric", 
"refcursor", "_refcursor", "regprocedure", "regoper", "regoperator", 
"regclass", "regtype", "regrole", "regnamespace", "_regprocedure", 
"_regoper", "_regoperator", "_regclass", "_regtype", "_regrole", 
"_regnamespace", "uuid", "_uuid", "pg_lsn", "_pg_lsn", "tsvector", 
"gtsvector", "tsquery", "regconfig", "regdictionary", "_tsvector", 
"_gtsvector", "_tsquery", "_regconfig", "_regdictionary", "jsonb", 
"_jsonb", "txid_snapshot", "_txid_snapshot", "int4range", "_int4range", 
"numrange", "_numrange", "tsrange", "_tsrange", "tstzrange", 
"_tstzrange", "daterange", "_daterange", "int8range", "_int8range", 
"record", "_record", "cstring", "any", "anyarray", "void", "trigger", 
"event_trigger", "language_handler", "internal", "opaque", "anyelement", 
"anynonarray", "anyenum", "fdw_handler", "index_am_handler", 
"tsm_handler", "anyrange", "pg_attrdef", "pg_constraint", "pg_inherits", 
"pg_index", "pg_operator", "pg_opfamily", "pg_opclass", "pg_am", 
"pg_amop", "pg_amproc", "pg_language", "pg_largeobject_metadata", 
"pg_largeobject", "pg_aggregate", "pg_statistic_ext", "pg_statistic", 
"pg_rewrite", "pg_trigger", "pg_event_trigger", "pg_description", 
"pg_cast", "pg_enum", "pg_namespace", "pg_conversion", "pg_depend", 
"pg_database", "pg_db_role_setting", "pg_tablespace", "pg_pltemplate", 
"pg_authid", "pg_auth_members", "pg_shdepend", "pg_shdescription", 
"pg_ts_config", "pg_ts_config_map", "pg_ts_dict", "pg_ts_parser", 
"pg_ts_template", "pg_extension", "pg_foreign_data_wrapper", 
"pg_foreign_server", "pg_user_mapping", "pg_foreign_table", "pg_policy", 
"pg_replication_origin", "pg_default_acl", "pg_init_privs", "pg_seclabel", 
"pg_shseclabel", "pg_collation", "pg_partitioned_table", "pg_range", 
"pg_transform", "pg_sequence", "pg_publication", "pg_publication_rel", 
"pg_subscription", "pg_subscription_rel", "pg_toast_2604", "pg_toast_2606", 
"pg_toast_2609", "pg_toast_1255", "pg_toast_2618", "pg_toast_3596", 
"pg_toast_2619", "pg_toast_3381", "pg_toast_2620", "pg_toast_2396", 
"pg_toast_2964", "pg_toast_3592", "pg_roles", "pg_shadow", "pg_group", 
"pg_user", "pg_policies", "pg_rules", "pg_views", "pg_tables", 
"pg_matviews", "pg_indexes", "pg_sequences", "pg_stats", "pg_publication_tables", 
"pg_locks", "pg_cursors", "pg_available_extensions", "pg_available_extension_versions", 
"pg_prepared_xacts", "pg_prepared_statements", "pg_seclabels", 
"pg_settings", "pg_file_settings", "pg_hba_file_rules", "pg_timezone_abbrevs", 
"pg_timezone_names", "pg_config", "pg_stat_all_tables", "pg_stat_xact_all_tables", 
"pg_stat_sys_tables", "pg_stat_xact_sys_tables", "pg_stat_user_tables", 
"pg_stat_xact_user_tables", "pg_statio_all_tables", "pg_statio_sys_tables", 
"pg_statio_user_tables", "pg_stat_all_indexes", "pg_stat_sys_indexes", 
"pg_stat_user_indexes", "pg_statio_all_indexes", "pg_statio_sys_indexes", 
"pg_statio_user_indexes", "pg_statio_all_sequences", "pg_statio_sys_sequences", 
"pg_statio_user_sequences", "pg_stat_activity", "pg_stat_replication", 
"pg_stat_wal_receiver", "pg_stat_subscription", "pg_stat_ssl", 
"pg_replication_slots", "pg_stat_database", "pg_stat_database_conflicts", 
"pg_stat_user_functions", "pg_stat_xact_user_functions", "pg_stat_archiver", 
"pg_stat_bgwriter", "pg_stat_progress_vacuum", "pg_user_mappings", 
"pg_replication_origin_status", "cardinal_number", "character_data", 
"sql_identifier", "information_schema_catalog_name", "time_stamp", 
"yes_or_no", "applicable_roles", "administrable_role_authorizations", 
"attributes", "character_sets", "check_constraint_routine_usage", 
"check_constraints", "collations", "collation_character_set_applicability", 
"column_domain_usage", "column_privileges", "column_udt_usage", 
"columns", "constraint_column_usage", "constraint_table_usage", 
"domain_constraints", "domain_udt_usage", "domains", "enabled_roles", 
"key_column_usage", "parameters", "referential_constraints", 
"role_column_grants", "routine_privileges", "role_routine_grants", 
"routines", "schemata", "sequences", "sql_features", "pg_toast_12853", 
"sql_implementation_info", "pg_toast_12858", "sql_languages", 
"pg_toast_12863", "sql_packages", "pg_toast_12868", "sql_parts", 
"pg_toast_12873", "sql_sizing", "pg_toast_12878", "sql_sizing_profiles", 
"pg_toast_12883", "table_constraints", "table_privileges", "role_table_grants", 
"tables", "transforms", "triggered_update_columns", "triggers", 
"udt_privileges", "role_udt_grants", "usage_privileges", "role_usage_grants", 
"user_defined_types", "view_column_usage", "view_routine_usage", 
"view_table_usage", "views", "data_type_privileges", "element_types", 
"_pg_foreign_table_columns", "column_options", "_pg_foreign_data_wrappers", 
"foreign_data_wrapper_options", "foreign_data_wrappers", "_pg_foreign_servers", 
"foreign_server_options", "foreign_servers", "_pg_foreign_tables", 
"foreign_table_options", "foreign_tables", "_pg_user_mappings", 
"user_mapping_options", "user_mappings", "attributes_countries", 
"_attributes_countries", "pg_toast_16502", "pg_toast_16514", 
"attributes_products_shortnames", "_attributes_products_shortnames", 
"hs07_yr", "_hs07_yr", "hs07_yrp", "_hs07_yrp", "hs07_yrpc", 
"_hs07_yrpc", "hs07_yrc", "_hs07_yrc", "hs07_yc", "_hs07_yc", 
"attributes_sections", "_attributes_sections", "attributes_sections_shortnames", 
"_attributes_sections_shortnames", "attributes_products_names", 
"attributes_groups", "_attributes_groups", "_attributes_products_names", 
"attributes_sections_names", "_attributes_sections_names", "attributes_sections_colors", 
"_attributes_sections_colors")), class = "data.frame", row.names = c(NA, 
-403L))