Generated DDL for Postgres indexes is missing index methods

Postgres supports different indexing methods (


The name of the index method to be used. Choices are btreehashgistspgistgin, and brin. The default method is btree.

Non-default index method is very important for index DDL. The parts in bold are missing from DataGrip-generated DDL.

CREATE INDEX ssd_wos_auth_source_id_index

  ON wos_authors USING hash (source_id) TABLESPACE ernie_index_tbs;



Comment actions Permalink


There is an issue you can track.

Thank you

Comment actions Permalink

The key type is still missing after 2+ years... ??

Comment actions Permalink

I agree. This should be prioritized in the next release. However, datagrip is a very fine tool. Keep up the good work Jet Brains Team. If you need help with this feature, please reach out to me. 


Please sign in to leave a comment.