I am using aws schema conversion tool for migration database oracle to PostgreSQL. I found an error which is not support in PostgreSQL. PostgreSQL doesn't support domain indexes. anyone know what is the solution of domain index in PostgreSQL?
CREATE INDEX CTX_IDX_UFA_EMAIL ON USR_ACCOUNT(EMAIL) INDEXTYPE IS CTXSYS.CTXCAT;
When I create this type of index, a table and a trigger are automatically created in the database. My question is PostgreSQL does not support this type of index. What is the alternative way to convert this type of index in PostgreSQL database that work like Oracle database?
Oracle docs: Using Extensible Indexing.
And more about the "Context"
CTXCAT index type.