{"author_name":"kurita1","version":"1.0","image_url":null,"author_url":"https://blog.hatena.ne.jp/kurita1/","categories":[],"type":"rich","provider_url":"https://hatena.blog","width":"100%","provider_name":"Hatena Blog","published":"2024-12-18 18:24:52","description":"There is actually, just query the pg_indexes system catalog view as follows: SELECT indexdef FROM pg_indexes WHERE indexname = '...'and you should get back the SQL statement used to define it.https://dba.stackexchange.com/questions/116797/is-there-a-way-to-show-the-creation-statement-for-an-index-in\u2026","height":"190","url":"https://kurita1.hatenadiary.com/entry/2024/12/18/182452","blog_title":"external storage 1","blog_url":"https://kurita1.hatenadiary.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkurita1.hatenadiary.com%2Fentry%2F2024%2F12%2F18%2F182452\" title=\"CREATE INDEX \u306eSQL\u78ba\u8a8d postgres - external storage 1\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"CREATE INDEX \u306eSQL\u78ba\u8a8d postgres"}