cakephp / phinx

     * @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;

    }

    /**

	 *

	 * @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;

	}

	/**

	 * {@inheritdoc}