Check out example codes for "postgresql create table with index". It will help you in understanding the concepts better.

Code Example 1

CREATE INDEX index_name
ON table_name (column_name);

Learn ReactJs, React Native from akashmittal.com