cakephp / phinx

     *

     * @return array

     */

    protected function getIndexes($tableName)

    {

        $indexes = [];

        $rows    = $this->fetchAll(sprintf('SHOW INDEXES FROM %s', $this->quoteTableName($tableName)));

        foreach ($rows as $row) {

            if (! isset($indexes[$row['Key_name']])) {

                $indexes[$row['Key_name']] = [ 'columns' => [] ];

            }

            $indexes[$row['Key_name']]['columns'][] = strtolower($row['Column_name']);

        }

        return $indexes;

    }

    /**

     * @param string $tableName Table Name

     * @return array

     */

    protected function getIndexes($tableName)

    {

        $indexes = [];

        $sql = "SELECT

            i.relname AS index_name,

            a.attname AS column_name

        FROM

            pg_class t,

            pg_class i,

            pg_index ix,

            pg_attribute a

        WHERE

            t.oid = ix.indrelid

            AND i.oid = ix.indexrelid

            AND a.attrelid = t.oid

            AND a.attnum = ANY(ix.indkey)

            AND t.relkind = 'r'

            AND t.relname = '$tableName'

        ORDER BY

            t.relname,

            i.relname;";

        $rows = $this->fetchAll($sql);

        foreach ($rows as $row) {

            if (!isset($indexes[$row['index_name']])) {

                $indexes[$row['index_name']] = ['columns' => []];

            }

            $indexes[$row['index_name']]['columns'][] = strtolower($row['column_name']);

        }

        return $indexes;

    }

    /**