123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308 |
- #----------------------------------------------------------------------
- #
- # pg_opfamily.dat
- # Initial contents of the pg_opfamily system catalog.
- #
- # Portions Copyright (c) 1996-2023, PostgreSQL Global Development Group
- # Portions Copyright (c) 1994, Regents of the University of California
- #
- # src/include/catalog/pg_opfamily.dat
- #
- #----------------------------------------------------------------------
- [
- { oid => '397',
- opfmethod => 'btree', opfname => 'array_ops' },
- { oid => '627',
- opfmethod => 'hash', opfname => 'array_ops' },
- { oid => '423',
- opfmethod => 'btree', opfname => 'bit_ops' },
- { oid => '424', oid_symbol => 'BOOL_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'bool_ops' },
- { oid => '426', oid_symbol => 'BPCHAR_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'bpchar_ops' },
- { oid => '427',
- opfmethod => 'hash', opfname => 'bpchar_ops' },
- { oid => '428', oid_symbol => 'BYTEA_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'bytea_ops' },
- { oid => '429',
- opfmethod => 'btree', opfname => 'char_ops' },
- { oid => '431',
- opfmethod => 'hash', opfname => 'char_ops' },
- { oid => '434',
- opfmethod => 'btree', opfname => 'datetime_ops' },
- { oid => '435',
- opfmethod => 'hash', opfname => 'date_ops' },
- { oid => '1970',
- opfmethod => 'btree', opfname => 'float_ops' },
- { oid => '1971',
- opfmethod => 'hash', opfname => 'float_ops' },
- { oid => '1974', oid_symbol => 'NETWORK_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'network_ops' },
- { oid => '1975',
- opfmethod => 'hash', opfname => 'network_ops' },
- { oid => '3550',
- opfmethod => 'gist', opfname => 'network_ops' },
- { oid => '3794',
- opfmethod => 'spgist', opfname => 'network_ops' },
- { oid => '1976', oid_symbol => 'INTEGER_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'integer_ops' },
- { oid => '1977',
- opfmethod => 'hash', opfname => 'integer_ops' },
- { oid => '1982', oid_symbol => 'INTERVAL_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'interval_ops' },
- { oid => '1983',
- opfmethod => 'hash', opfname => 'interval_ops' },
- { oid => '1984',
- opfmethod => 'btree', opfname => 'macaddr_ops' },
- { oid => '1985',
- opfmethod => 'hash', opfname => 'macaddr_ops' },
- { oid => '3371',
- opfmethod => 'btree', opfname => 'macaddr8_ops' },
- { oid => '3372',
- opfmethod => 'hash', opfname => 'macaddr8_ops' },
- { oid => '1988',
- opfmethod => 'btree', opfname => 'numeric_ops' },
- { oid => '1998',
- opfmethod => 'hash', opfname => 'numeric_ops' },
- { oid => '1989', oid_symbol => 'OID_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'oid_ops' },
- { oid => '1990',
- opfmethod => 'hash', opfname => 'oid_ops' },
- { oid => '1991',
- opfmethod => 'btree', opfname => 'oidvector_ops' },
- { oid => '1992',
- opfmethod => 'hash', opfname => 'oidvector_ops' },
- { oid => '2994',
- opfmethod => 'btree', opfname => 'record_ops' },
- { oid => '6194',
- opfmethod => 'hash', opfname => 'record_ops' },
- { oid => '3194',
- opfmethod => 'btree', opfname => 'record_image_ops' },
- { oid => '1994', oid_symbol => 'TEXT_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'text_ops' },
- { oid => '1995',
- opfmethod => 'hash', opfname => 'text_ops' },
- { oid => '1996',
- opfmethod => 'btree', opfname => 'time_ops' },
- { oid => '1997',
- opfmethod => 'hash', opfname => 'time_ops' },
- { oid => '1999',
- opfmethod => 'hash', opfname => 'timestamptz_ops' },
- { oid => '2000',
- opfmethod => 'btree', opfname => 'timetz_ops' },
- { oid => '2001',
- opfmethod => 'hash', opfname => 'timetz_ops' },
- { oid => '2002',
- opfmethod => 'btree', opfname => 'varbit_ops' },
- { oid => '2040',
- opfmethod => 'hash', opfname => 'timestamp_ops' },
- { oid => '2095', oid_symbol => 'TEXT_PATTERN_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'text_pattern_ops' },
- { oid => '2097', oid_symbol => 'BPCHAR_PATTERN_BTREE_FAM_OID',
- opfmethod => 'btree', opfname => 'bpchar_pattern_ops' },
- { oid => '2099',
- opfmethod => 'btree', opfname => 'money_ops' },
- { oid => '2222', oid_symbol => 'BOOL_HASH_FAM_OID',
- opfmethod => 'hash', opfname => 'bool_ops' },
- { oid => '2223',
- opfmethod => 'hash', opfname => 'bytea_ops' },
- { oid => '2789',
- opfmethod => 'btree', opfname => 'tid_ops' },
- { oid => '2225',
- opfmethod => 'hash', opfname => 'xid_ops' },
- { oid => '5032',
- opfmethod => 'hash', opfname => 'xid8_ops' },
- { oid => '5067',
- opfmethod => 'btree', opfname => 'xid8_ops' },
- { oid => '2226',
- opfmethod => 'hash', opfname => 'cid_ops' },
- { oid => '2227',
- opfmethod => 'hash', opfname => 'tid_ops' },
- { oid => '2229',
- opfmethod => 'hash', opfname => 'text_pattern_ops' },
- { oid => '2231',
- opfmethod => 'hash', opfname => 'bpchar_pattern_ops' },
- { oid => '2235',
- opfmethod => 'hash', opfname => 'aclitem_ops' },
- { oid => '2593',
- opfmethod => 'gist', opfname => 'box_ops' },
- { oid => '2594',
- opfmethod => 'gist', opfname => 'poly_ops' },
- { oid => '2595',
- opfmethod => 'gist', opfname => 'circle_ops' },
- { oid => '1029',
- opfmethod => 'gist', opfname => 'point_ops' },
- { oid => '2745',
- opfmethod => 'gin', opfname => 'array_ops' },
- { oid => '2968',
- opfmethod => 'btree', opfname => 'uuid_ops' },
- { oid => '2969',
- opfmethod => 'hash', opfname => 'uuid_ops' },
- { oid => '3253',
- opfmethod => 'btree', opfname => 'pg_lsn_ops' },
- { oid => '3254',
- opfmethod => 'hash', opfname => 'pg_lsn_ops' },
- { oid => '3522',
- opfmethod => 'btree', opfname => 'enum_ops' },
- { oid => '3523',
- opfmethod => 'hash', opfname => 'enum_ops' },
- { oid => '3626',
- opfmethod => 'btree', opfname => 'tsvector_ops' },
- { oid => '3655',
- opfmethod => 'gist', opfname => 'tsvector_ops' },
- { oid => '3659',
- opfmethod => 'gin', opfname => 'tsvector_ops' },
- { oid => '3683',
- opfmethod => 'btree', opfname => 'tsquery_ops' },
- { oid => '3702',
- opfmethod => 'gist', opfname => 'tsquery_ops' },
- { oid => '3901',
- opfmethod => 'btree', opfname => 'range_ops' },
- { oid => '3903',
- opfmethod => 'hash', opfname => 'range_ops' },
- { oid => '3919',
- opfmethod => 'gist', opfname => 'range_ops' },
- { oid => '3474',
- opfmethod => 'spgist', opfname => 'range_ops' },
- { oid => '4015',
- opfmethod => 'spgist', opfname => 'quad_point_ops' },
- { oid => '4016',
- opfmethod => 'spgist', opfname => 'kd_point_ops' },
- { oid => '4017', oid_symbol => 'TEXT_SPGIST_FAM_OID',
- opfmethod => 'spgist', opfname => 'text_ops' },
- { oid => '4033',
- opfmethod => 'btree', opfname => 'jsonb_ops' },
- { oid => '4034',
- opfmethod => 'hash', opfname => 'jsonb_ops' },
- { oid => '4036',
- opfmethod => 'gin', opfname => 'jsonb_ops' },
- { oid => '4037',
- opfmethod => 'gin', opfname => 'jsonb_path_ops' },
- { oid => '4054',
- opfmethod => 'brin', opfname => 'integer_minmax_ops' },
- { oid => '4602',
- opfmethod => 'brin', opfname => 'integer_minmax_multi_ops' },
- { oid => '4572',
- opfmethod => 'brin', opfname => 'integer_bloom_ops' },
- { oid => '4055',
- opfmethod => 'brin', opfname => 'numeric_minmax_ops' },
- { oid => '4603',
- opfmethod => 'brin', opfname => 'numeric_minmax_multi_ops' },
- { oid => '4056',
- opfmethod => 'brin', opfname => 'text_minmax_ops' },
- { oid => '4573',
- opfmethod => 'brin', opfname => 'text_bloom_ops' },
- { oid => '4574',
- opfmethod => 'brin', opfname => 'numeric_bloom_ops' },
- { oid => '4058',
- opfmethod => 'brin', opfname => 'timetz_minmax_ops' },
- { oid => '4604',
- opfmethod => 'brin', opfname => 'timetz_minmax_multi_ops' },
- { oid => '4575',
- opfmethod => 'brin', opfname => 'timetz_bloom_ops' },
- { oid => '4059',
- opfmethod => 'brin', opfname => 'datetime_minmax_ops' },
- { oid => '4605',
- opfmethod => 'brin', opfname => 'datetime_minmax_multi_ops' },
- { oid => '4576',
- opfmethod => 'brin', opfname => 'datetime_bloom_ops' },
- { oid => '4062',
- opfmethod => 'brin', opfname => 'char_minmax_ops' },
- { oid => '4577',
- opfmethod => 'brin', opfname => 'char_bloom_ops' },
- { oid => '4064',
- opfmethod => 'brin', opfname => 'bytea_minmax_ops' },
- { oid => '4578',
- opfmethod => 'brin', opfname => 'bytea_bloom_ops' },
- { oid => '4065',
- opfmethod => 'brin', opfname => 'name_minmax_ops' },
- { oid => '4579',
- opfmethod => 'brin', opfname => 'name_bloom_ops' },
- { oid => '4068',
- opfmethod => 'brin', opfname => 'oid_minmax_ops' },
- { oid => '4606',
- opfmethod => 'brin', opfname => 'oid_minmax_multi_ops' },
- { oid => '4580',
- opfmethod => 'brin', opfname => 'oid_bloom_ops' },
- { oid => '4069',
- opfmethod => 'brin', opfname => 'tid_minmax_ops' },
- { oid => '4581',
- opfmethod => 'brin', opfname => 'tid_bloom_ops' },
- { oid => '4607',
- opfmethod => 'brin', opfname => 'tid_minmax_multi_ops' },
- { oid => '4070',
- opfmethod => 'brin', opfname => 'float_minmax_ops' },
- { oid => '4608',
- opfmethod => 'brin', opfname => 'float_minmax_multi_ops' },
- { oid => '4582',
- opfmethod => 'brin', opfname => 'float_bloom_ops' },
- { oid => '4074',
- opfmethod => 'brin', opfname => 'macaddr_minmax_ops' },
- { oid => '4609',
- opfmethod => 'brin', opfname => 'macaddr_minmax_multi_ops' },
- { oid => '4583',
- opfmethod => 'brin', opfname => 'macaddr_bloom_ops' },
- { oid => '4109',
- opfmethod => 'brin', opfname => 'macaddr8_minmax_ops' },
- { oid => '4610',
- opfmethod => 'brin', opfname => 'macaddr8_minmax_multi_ops' },
- { oid => '4584',
- opfmethod => 'brin', opfname => 'macaddr8_bloom_ops' },
- { oid => '4075',
- opfmethod => 'brin', opfname => 'network_minmax_ops' },
- { oid => '4611',
- opfmethod => 'brin', opfname => 'network_minmax_multi_ops' },
- { oid => '4102',
- opfmethod => 'brin', opfname => 'network_inclusion_ops' },
- { oid => '4585',
- opfmethod => 'brin', opfname => 'network_bloom_ops' },
- { oid => '4076',
- opfmethod => 'brin', opfname => 'bpchar_minmax_ops' },
- { oid => '4586',
- opfmethod => 'brin', opfname => 'bpchar_bloom_ops' },
- { oid => '4077',
- opfmethod => 'brin', opfname => 'time_minmax_ops' },
- { oid => '4612',
- opfmethod => 'brin', opfname => 'time_minmax_multi_ops' },
- { oid => '4587',
- opfmethod => 'brin', opfname => 'time_bloom_ops' },
- { oid => '4078',
- opfmethod => 'brin', opfname => 'interval_minmax_ops' },
- { oid => '4613',
- opfmethod => 'brin', opfname => 'interval_minmax_multi_ops' },
- { oid => '4588',
- opfmethod => 'brin', opfname => 'interval_bloom_ops' },
- { oid => '4079',
- opfmethod => 'brin', opfname => 'bit_minmax_ops' },
- { oid => '4080',
- opfmethod => 'brin', opfname => 'varbit_minmax_ops' },
- { oid => '4081',
- opfmethod => 'brin', opfname => 'uuid_minmax_ops' },
- { oid => '4614',
- opfmethod => 'brin', opfname => 'uuid_minmax_multi_ops' },
- { oid => '4589',
- opfmethod => 'brin', opfname => 'uuid_bloom_ops' },
- { oid => '4103',
- opfmethod => 'brin', opfname => 'range_inclusion_ops' },
- { oid => '4082',
- opfmethod => 'brin', opfname => 'pg_lsn_minmax_ops' },
- { oid => '4615',
- opfmethod => 'brin', opfname => 'pg_lsn_minmax_multi_ops' },
- { oid => '4590',
- opfmethod => 'brin', opfname => 'pg_lsn_bloom_ops' },
- { oid => '4104',
- opfmethod => 'brin', opfname => 'box_inclusion_ops' },
- { oid => '5000',
- opfmethod => 'spgist', opfname => 'box_ops' },
- { oid => '5008',
- opfmethod => 'spgist', opfname => 'poly_ops' },
- { oid => '4199',
- opfmethod => 'btree', opfname => 'multirange_ops' },
- { oid => '4225',
- opfmethod => 'hash', opfname => 'multirange_ops' },
- { oid => '6158',
- opfmethod => 'gist', opfname => 'multirange_ops' },
- ]
|