Related

Create Database

psql

Create a new PostgreSQL database

Create User

psql

Create a new PostgreSQL user

Create Table

psql

Create a new PostgreSQL table

psql/create-index

Create Index

Create a new PostgreSQL index

index
create

Command

CREATE INDEX indexname ON tablename (columnname);

Explanation

Creates a new index on the specified column.

Examples

Create index on email column

CREATE INDEX idx_users_email ON users (email);

More

Drop Index

psql

Delete a PostgreSQL index

Create View

psql

Create a new PostgreSQL view

Create Function

psql

Create a new PostgreSQL function