CREATE INDEX のSQL確認 postgres

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-postgresql