Generated DDL for Postgres indexes is missing index methods

Postgres supports different indexing methods (https://www.postgresql.org/docs/9.6/static/sql-createindex.html):

method

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;

 

 

3 comments
Comment actions Permalink

Hi,

There is an issue https://youtrack.jetbrains.com/issue/DBE-5399 you can track.

Thank you

-1
Comment actions Permalink

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

2
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. 

0

Please sign in to leave a comment.