pg_opfamily.dat 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308
  1. #----------------------------------------------------------------------
  2. #
  3. # pg_opfamily.dat
  4. # Initial contents of the pg_opfamily system catalog.
  5. #
  6. # Portions Copyright (c) 1996-2023, PostgreSQL Global Development Group
  7. # Portions Copyright (c) 1994, Regents of the University of California
  8. #
  9. # src/include/catalog/pg_opfamily.dat
  10. #
  11. #----------------------------------------------------------------------
  12. [
  13. { oid => '397',
  14. opfmethod => 'btree', opfname => 'array_ops' },
  15. { oid => '627',
  16. opfmethod => 'hash', opfname => 'array_ops' },
  17. { oid => '423',
  18. opfmethod => 'btree', opfname => 'bit_ops' },
  19. { oid => '424', oid_symbol => 'BOOL_BTREE_FAM_OID',
  20. opfmethod => 'btree', opfname => 'bool_ops' },
  21. { oid => '426', oid_symbol => 'BPCHAR_BTREE_FAM_OID',
  22. opfmethod => 'btree', opfname => 'bpchar_ops' },
  23. { oid => '427',
  24. opfmethod => 'hash', opfname => 'bpchar_ops' },
  25. { oid => '428', oid_symbol => 'BYTEA_BTREE_FAM_OID',
  26. opfmethod => 'btree', opfname => 'bytea_ops' },
  27. { oid => '429',
  28. opfmethod => 'btree', opfname => 'char_ops' },
  29. { oid => '431',
  30. opfmethod => 'hash', opfname => 'char_ops' },
  31. { oid => '434',
  32. opfmethod => 'btree', opfname => 'datetime_ops' },
  33. { oid => '435',
  34. opfmethod => 'hash', opfname => 'date_ops' },
  35. { oid => '1970',
  36. opfmethod => 'btree', opfname => 'float_ops' },
  37. { oid => '1971',
  38. opfmethod => 'hash', opfname => 'float_ops' },
  39. { oid => '1974', oid_symbol => 'NETWORK_BTREE_FAM_OID',
  40. opfmethod => 'btree', opfname => 'network_ops' },
  41. { oid => '1975',
  42. opfmethod => 'hash', opfname => 'network_ops' },
  43. { oid => '3550',
  44. opfmethod => 'gist', opfname => 'network_ops' },
  45. { oid => '3794',
  46. opfmethod => 'spgist', opfname => 'network_ops' },
  47. { oid => '1976', oid_symbol => 'INTEGER_BTREE_FAM_OID',
  48. opfmethod => 'btree', opfname => 'integer_ops' },
  49. { oid => '1977',
  50. opfmethod => 'hash', opfname => 'integer_ops' },
  51. { oid => '1982', oid_symbol => 'INTERVAL_BTREE_FAM_OID',
  52. opfmethod => 'btree', opfname => 'interval_ops' },
  53. { oid => '1983',
  54. opfmethod => 'hash', opfname => 'interval_ops' },
  55. { oid => '1984',
  56. opfmethod => 'btree', opfname => 'macaddr_ops' },
  57. { oid => '1985',
  58. opfmethod => 'hash', opfname => 'macaddr_ops' },
  59. { oid => '3371',
  60. opfmethod => 'btree', opfname => 'macaddr8_ops' },
  61. { oid => '3372',
  62. opfmethod => 'hash', opfname => 'macaddr8_ops' },
  63. { oid => '1988',
  64. opfmethod => 'btree', opfname => 'numeric_ops' },
  65. { oid => '1998',
  66. opfmethod => 'hash', opfname => 'numeric_ops' },
  67. { oid => '1989', oid_symbol => 'OID_BTREE_FAM_OID',
  68. opfmethod => 'btree', opfname => 'oid_ops' },
  69. { oid => '1990',
  70. opfmethod => 'hash', opfname => 'oid_ops' },
  71. { oid => '1991',
  72. opfmethod => 'btree', opfname => 'oidvector_ops' },
  73. { oid => '1992',
  74. opfmethod => 'hash', opfname => 'oidvector_ops' },
  75. { oid => '2994',
  76. opfmethod => 'btree', opfname => 'record_ops' },
  77. { oid => '6194',
  78. opfmethod => 'hash', opfname => 'record_ops' },
  79. { oid => '3194',
  80. opfmethod => 'btree', opfname => 'record_image_ops' },
  81. { oid => '1994', oid_symbol => 'TEXT_BTREE_FAM_OID',
  82. opfmethod => 'btree', opfname => 'text_ops' },
  83. { oid => '1995',
  84. opfmethod => 'hash', opfname => 'text_ops' },
  85. { oid => '1996',
  86. opfmethod => 'btree', opfname => 'time_ops' },
  87. { oid => '1997',
  88. opfmethod => 'hash', opfname => 'time_ops' },
  89. { oid => '1999',
  90. opfmethod => 'hash', opfname => 'timestamptz_ops' },
  91. { oid => '2000',
  92. opfmethod => 'btree', opfname => 'timetz_ops' },
  93. { oid => '2001',
  94. opfmethod => 'hash', opfname => 'timetz_ops' },
  95. { oid => '2002',
  96. opfmethod => 'btree', opfname => 'varbit_ops' },
  97. { oid => '2040',
  98. opfmethod => 'hash', opfname => 'timestamp_ops' },
  99. { oid => '2095', oid_symbol => 'TEXT_PATTERN_BTREE_FAM_OID',
  100. opfmethod => 'btree', opfname => 'text_pattern_ops' },
  101. { oid => '2097', oid_symbol => 'BPCHAR_PATTERN_BTREE_FAM_OID',
  102. opfmethod => 'btree', opfname => 'bpchar_pattern_ops' },
  103. { oid => '2099',
  104. opfmethod => 'btree', opfname => 'money_ops' },
  105. { oid => '2222', oid_symbol => 'BOOL_HASH_FAM_OID',
  106. opfmethod => 'hash', opfname => 'bool_ops' },
  107. { oid => '2223',
  108. opfmethod => 'hash', opfname => 'bytea_ops' },
  109. { oid => '2789',
  110. opfmethod => 'btree', opfname => 'tid_ops' },
  111. { oid => '2225',
  112. opfmethod => 'hash', opfname => 'xid_ops' },
  113. { oid => '5032',
  114. opfmethod => 'hash', opfname => 'xid8_ops' },
  115. { oid => '5067',
  116. opfmethod => 'btree', opfname => 'xid8_ops' },
  117. { oid => '2226',
  118. opfmethod => 'hash', opfname => 'cid_ops' },
  119. { oid => '2227',
  120. opfmethod => 'hash', opfname => 'tid_ops' },
  121. { oid => '2229',
  122. opfmethod => 'hash', opfname => 'text_pattern_ops' },
  123. { oid => '2231',
  124. opfmethod => 'hash', opfname => 'bpchar_pattern_ops' },
  125. { oid => '2235',
  126. opfmethod => 'hash', opfname => 'aclitem_ops' },
  127. { oid => '2593',
  128. opfmethod => 'gist', opfname => 'box_ops' },
  129. { oid => '2594',
  130. opfmethod => 'gist', opfname => 'poly_ops' },
  131. { oid => '2595',
  132. opfmethod => 'gist', opfname => 'circle_ops' },
  133. { oid => '1029',
  134. opfmethod => 'gist', opfname => 'point_ops' },
  135. { oid => '2745',
  136. opfmethod => 'gin', opfname => 'array_ops' },
  137. { oid => '2968',
  138. opfmethod => 'btree', opfname => 'uuid_ops' },
  139. { oid => '2969',
  140. opfmethod => 'hash', opfname => 'uuid_ops' },
  141. { oid => '3253',
  142. opfmethod => 'btree', opfname => 'pg_lsn_ops' },
  143. { oid => '3254',
  144. opfmethod => 'hash', opfname => 'pg_lsn_ops' },
  145. { oid => '3522',
  146. opfmethod => 'btree', opfname => 'enum_ops' },
  147. { oid => '3523',
  148. opfmethod => 'hash', opfname => 'enum_ops' },
  149. { oid => '3626',
  150. opfmethod => 'btree', opfname => 'tsvector_ops' },
  151. { oid => '3655',
  152. opfmethod => 'gist', opfname => 'tsvector_ops' },
  153. { oid => '3659',
  154. opfmethod => 'gin', opfname => 'tsvector_ops' },
  155. { oid => '3683',
  156. opfmethod => 'btree', opfname => 'tsquery_ops' },
  157. { oid => '3702',
  158. opfmethod => 'gist', opfname => 'tsquery_ops' },
  159. { oid => '3901',
  160. opfmethod => 'btree', opfname => 'range_ops' },
  161. { oid => '3903',
  162. opfmethod => 'hash', opfname => 'range_ops' },
  163. { oid => '3919',
  164. opfmethod => 'gist', opfname => 'range_ops' },
  165. { oid => '3474',
  166. opfmethod => 'spgist', opfname => 'range_ops' },
  167. { oid => '4015',
  168. opfmethod => 'spgist', opfname => 'quad_point_ops' },
  169. { oid => '4016',
  170. opfmethod => 'spgist', opfname => 'kd_point_ops' },
  171. { oid => '4017', oid_symbol => 'TEXT_SPGIST_FAM_OID',
  172. opfmethod => 'spgist', opfname => 'text_ops' },
  173. { oid => '4033',
  174. opfmethod => 'btree', opfname => 'jsonb_ops' },
  175. { oid => '4034',
  176. opfmethod => 'hash', opfname => 'jsonb_ops' },
  177. { oid => '4036',
  178. opfmethod => 'gin', opfname => 'jsonb_ops' },
  179. { oid => '4037',
  180. opfmethod => 'gin', opfname => 'jsonb_path_ops' },
  181. { oid => '4054',
  182. opfmethod => 'brin', opfname => 'integer_minmax_ops' },
  183. { oid => '4602',
  184. opfmethod => 'brin', opfname => 'integer_minmax_multi_ops' },
  185. { oid => '4572',
  186. opfmethod => 'brin', opfname => 'integer_bloom_ops' },
  187. { oid => '4055',
  188. opfmethod => 'brin', opfname => 'numeric_minmax_ops' },
  189. { oid => '4603',
  190. opfmethod => 'brin', opfname => 'numeric_minmax_multi_ops' },
  191. { oid => '4056',
  192. opfmethod => 'brin', opfname => 'text_minmax_ops' },
  193. { oid => '4573',
  194. opfmethod => 'brin', opfname => 'text_bloom_ops' },
  195. { oid => '4574',
  196. opfmethod => 'brin', opfname => 'numeric_bloom_ops' },
  197. { oid => '4058',
  198. opfmethod => 'brin', opfname => 'timetz_minmax_ops' },
  199. { oid => '4604',
  200. opfmethod => 'brin', opfname => 'timetz_minmax_multi_ops' },
  201. { oid => '4575',
  202. opfmethod => 'brin', opfname => 'timetz_bloom_ops' },
  203. { oid => '4059',
  204. opfmethod => 'brin', opfname => 'datetime_minmax_ops' },
  205. { oid => '4605',
  206. opfmethod => 'brin', opfname => 'datetime_minmax_multi_ops' },
  207. { oid => '4576',
  208. opfmethod => 'brin', opfname => 'datetime_bloom_ops' },
  209. { oid => '4062',
  210. opfmethod => 'brin', opfname => 'char_minmax_ops' },
  211. { oid => '4577',
  212. opfmethod => 'brin', opfname => 'char_bloom_ops' },
  213. { oid => '4064',
  214. opfmethod => 'brin', opfname => 'bytea_minmax_ops' },
  215. { oid => '4578',
  216. opfmethod => 'brin', opfname => 'bytea_bloom_ops' },
  217. { oid => '4065',
  218. opfmethod => 'brin', opfname => 'name_minmax_ops' },
  219. { oid => '4579',
  220. opfmethod => 'brin', opfname => 'name_bloom_ops' },
  221. { oid => '4068',
  222. opfmethod => 'brin', opfname => 'oid_minmax_ops' },
  223. { oid => '4606',
  224. opfmethod => 'brin', opfname => 'oid_minmax_multi_ops' },
  225. { oid => '4580',
  226. opfmethod => 'brin', opfname => 'oid_bloom_ops' },
  227. { oid => '4069',
  228. opfmethod => 'brin', opfname => 'tid_minmax_ops' },
  229. { oid => '4581',
  230. opfmethod => 'brin', opfname => 'tid_bloom_ops' },
  231. { oid => '4607',
  232. opfmethod => 'brin', opfname => 'tid_minmax_multi_ops' },
  233. { oid => '4070',
  234. opfmethod => 'brin', opfname => 'float_minmax_ops' },
  235. { oid => '4608',
  236. opfmethod => 'brin', opfname => 'float_minmax_multi_ops' },
  237. { oid => '4582',
  238. opfmethod => 'brin', opfname => 'float_bloom_ops' },
  239. { oid => '4074',
  240. opfmethod => 'brin', opfname => 'macaddr_minmax_ops' },
  241. { oid => '4609',
  242. opfmethod => 'brin', opfname => 'macaddr_minmax_multi_ops' },
  243. { oid => '4583',
  244. opfmethod => 'brin', opfname => 'macaddr_bloom_ops' },
  245. { oid => '4109',
  246. opfmethod => 'brin', opfname => 'macaddr8_minmax_ops' },
  247. { oid => '4610',
  248. opfmethod => 'brin', opfname => 'macaddr8_minmax_multi_ops' },
  249. { oid => '4584',
  250. opfmethod => 'brin', opfname => 'macaddr8_bloom_ops' },
  251. { oid => '4075',
  252. opfmethod => 'brin', opfname => 'network_minmax_ops' },
  253. { oid => '4611',
  254. opfmethod => 'brin', opfname => 'network_minmax_multi_ops' },
  255. { oid => '4102',
  256. opfmethod => 'brin', opfname => 'network_inclusion_ops' },
  257. { oid => '4585',
  258. opfmethod => 'brin', opfname => 'network_bloom_ops' },
  259. { oid => '4076',
  260. opfmethod => 'brin', opfname => 'bpchar_minmax_ops' },
  261. { oid => '4586',
  262. opfmethod => 'brin', opfname => 'bpchar_bloom_ops' },
  263. { oid => '4077',
  264. opfmethod => 'brin', opfname => 'time_minmax_ops' },
  265. { oid => '4612',
  266. opfmethod => 'brin', opfname => 'time_minmax_multi_ops' },
  267. { oid => '4587',
  268. opfmethod => 'brin', opfname => 'time_bloom_ops' },
  269. { oid => '4078',
  270. opfmethod => 'brin', opfname => 'interval_minmax_ops' },
  271. { oid => '4613',
  272. opfmethod => 'brin', opfname => 'interval_minmax_multi_ops' },
  273. { oid => '4588',
  274. opfmethod => 'brin', opfname => 'interval_bloom_ops' },
  275. { oid => '4079',
  276. opfmethod => 'brin', opfname => 'bit_minmax_ops' },
  277. { oid => '4080',
  278. opfmethod => 'brin', opfname => 'varbit_minmax_ops' },
  279. { oid => '4081',
  280. opfmethod => 'brin', opfname => 'uuid_minmax_ops' },
  281. { oid => '4614',
  282. opfmethod => 'brin', opfname => 'uuid_minmax_multi_ops' },
  283. { oid => '4589',
  284. opfmethod => 'brin', opfname => 'uuid_bloom_ops' },
  285. { oid => '4103',
  286. opfmethod => 'brin', opfname => 'range_inclusion_ops' },
  287. { oid => '4082',
  288. opfmethod => 'brin', opfname => 'pg_lsn_minmax_ops' },
  289. { oid => '4615',
  290. opfmethod => 'brin', opfname => 'pg_lsn_minmax_multi_ops' },
  291. { oid => '4590',
  292. opfmethod => 'brin', opfname => 'pg_lsn_bloom_ops' },
  293. { oid => '4104',
  294. opfmethod => 'brin', opfname => 'box_inclusion_ops' },
  295. { oid => '5000',
  296. opfmethod => 'spgist', opfname => 'box_ops' },
  297. { oid => '5008',
  298. opfmethod => 'spgist', opfname => 'poly_ops' },
  299. { oid => '4199',
  300. opfmethod => 'btree', opfname => 'multirange_ops' },
  301. { oid => '4225',
  302. opfmethod => 'hash', opfname => 'multirange_ops' },
  303. { oid => '6158',
  304. opfmethod => 'gist', opfname => 'multirange_ops' },
  305. ]