Generated DDL for Postgres indexes is missing index methods Follow
Postgres supports different indexing methods (https://www.postgresql.org/docs/9.6/static/sql-createindex.html):
The name of the index method to be used. Choices are btree, hash, gist, spgist, gin, 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;
Please sign in to leave a comment.
There is an issue https://youtrack.jetbrains.com/issue/DBE-5399 you can track.
The key type is still missing after 2+ years... ??
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.