CREATE INDEX index_name ON table_name(column_name);
SELECT tablename, indexname, indexdef FROM pg_indexes;
CREATE INDEX <index_name> ON <table_name> (<column_name>);