link
psql/create-index

Create Index

Create a new PostgreSQL index

index
create

Command

CREATE INDEX indexname ON tablename (columnname);

Examples

Create index on email column

CREATE INDEX idx_users_email ON users (email);