kingbasees查询指定库的所有索引的sql
时间: 2024-02-11 07:04:52 浏览: 26
您可以使用以下 SQL 查询语句来获取指定库的所有索引信息:
```sql
SELECT
t.relname AS table_name,
c.relname AS index_name,
a.attname AS column_name
FROM
pg_class AS c
INNER JOIN pg_index AS i ON c.oid = i.indexrelid
INNER JOIN pg_class AS t ON i.indrelid = t.oid
INNER JOIN pg_attribute AS a ON a.attrelid = t.oid AND a.attnum = ANY(i.indkey)
WHERE
c.relkind = 'i'
AND t.relname = 'your_table_name'
AND t.relnamespace IN (
SELECT
oid
FROM
pg_namespace
WHERE
nspname NOT LIKE 'pg_%'
AND nspname != 'information_schema'
)
ORDER BY
t.relname,
c.relname;
```
请将 `your_table_name` 替换为您要查询的表的名称。这个查询语句将返回指定表的所有索引及其包含的列信息。