Method getIndexDefsForTables

database/postgres/database.go:1392–1430

(tableNames []string)

}

func (d *PostgresDatabase) getIndexDefsForTables(tableNames []string) (map[string][]string, error) {
	// Exclude indexes that are implicitly created for primary keys or unique constraints or exclusion constraints.
	const query = `WITH
	  exclude_constraints AS (
	    SELECT con.conname AS name, nsp.nspname || '.' || cls.relname AS qualified_table_name
	    FROM   pg_constraint con
	    JOIN   pg_namespace nsp ON nsp.oid = con.connamespace
	    JOIN   pg_class cls ON cls.oid = con.conrelid
	    WHERE  con.contype IN ('p', 'u', 'x')
	    AND    nsp.nspname || '.' || cls.relname = ANY($1::text[])
	  )
	SELECT schemaname || '.' || tablename AS qualified_table_name, indexName, indexdef
	FROM   pg_indexes
	WHERE  schemaname || '.' || tablename = ANY($1::text[])
	AND    indexName NOT IN (
	    SELECT name FROM exclude_constraints
	    WHERE  qualified_table_name = schemaname || '.' || tablename
	)
	ORDER BY schemaname, tablename, indexdef
	`

	rows, err := d.db.Query(query, pq.Array(tableNames))
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	result := make(map[string][]string, len(tableNames))
	for rows.Next() {
		var tableName, indexName, indexdef string
		err = rows.Scan(&tableName, &indexName, &indexdef)
		if err != nil {
			return nil, err
		}
		indexName = strings.Trim(indexName, `" `)
		result[tableName] = append(result[tableName], indexdef)
	}
	return result, nil
}

// refs: https://gist.github.com/PickledDragon/dd41f4e72b428175354d
func (d *PostgresDatabase) getForeignDefsForTables(tableNames []string) (map[string][]string, error) {