pg查看表结构中的字段索引

Question

如图mysql查询表结构有column_key代表字段索引的信息。
但是pg查询表结构没有column_key，如下哪个字段是代pg表的索引信息呢

                    "scope_schema": "null",
                    "is_nullable": "NO",
                    "column_default": "nextval('config_info_id_seq'::regclass)",
                    "is_updatable": "YES",
                    "maximum_cardinality": "null",
                    "identity_minimum": "null",
                    "numeric_scale": "0",
                    "is_self_referencing": "NO",
                    "table_catalog": "nacos",
                    "table_name": "config_info",
                    "scope_name": "null",
                    "is_generated": "NEVER",
                    "collation_catalog": "null",
                    "domain_name": "null",
                    "character_set_name": "null",
                    "identity_generation": "null",
                    "identity_cycle": "NO",
                    "interval_type": "null",
                    "datetime_precision": "null",
                    "collation_schema": "null",
                    "scope_catalog": "null",
                    "column_name": "id",
                    "character_maximum_length": "null",
                    "generation_expression": "null",
                    "collation_name": "null",
                    "is_identity": "NO",
                    "character_set_catalog": "null",
                    "domain_catalog": "null",
                    "interval_precision": "null",
                    "character_set_schema": "null",
                    "identity_increment": "null",
                    "domain_schema": "null",
                    "ordinal_position": "1",
                    "identity_maximum": "null",
                    "table_schema": "public",
                    "data_type": "integer",
                    "udt_catalog": "nacos",
                    "numeric_precision": "32",
                    "dtd_identifier": "1",
                    "character_octet_length": "null",
                    "identity_start": "null",
                    "udt_name": "int4",
                    "udt_schema": "pg_catalog"

Answer 1

pg_indexes 是一个视图，可以通过它获取某个表的索引信息。

SELECT
    n.nspname AS schemaname,
    c.relname AS tablename,
    i.relname AS indexname,
    t.spcname AS tablespace,
    pg_get_indexdef(i.oid) AS indexdef
FROM pg_index x
    JOIN pg_class c ON c.oid = x.indrelid
    JOIN pg_class i ON i.oid = x.indexrelid
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN pg_tablespace t ON t.oid = i.reltablespace
WHERE (c.relkind = ANY (ARRAY['r'::"char", 'm'::"char"])) AND i.relkind = 'i'::"char";