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.
create index on usr_account(email)
?INDEXTYPE
and how it is used, what performance gain you get, etc). Otherwise, only Oracle experts will knwo what you are talking about (but probably have no idea how that can be done in Postgres) and Postgres experts may know how to do it but no idea what you are talking about. You'll be just gambling that an expert in both DBMS will stumble on the question ;)