Answers for "postgres do in work with index"

query for all indexes in table postgres

SELECT
    tablename,
    indexname,
    indexdef
FROM
    pg_indexes
WHERE
    schemaname = 'public'
ORDER BY
    tablename,
    indexname;

Posted by: Guest on October-25-2021

postgres how to index a column

CREATE INDEX index_name 
ON table_name(column_name);

Posted by: Guest on June-10-2021

Code answers related to "postgres do in work with index"