Method getCheckConstraintsForTables

database/postgres/database.go:1647–1678

(tableNames []string)

}

func (d *PostgresDatabase) getCheckConstraintsForTables(tableNames []string) (map[string][]CheckConstraint, error) {
	const query = `SELECT nsp.nspname || '.' || cls.relname AS qualified_table_name, con.conname, pg_get_constraintdef(con.oid, true)
	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 = 'c'
	AND    nsp.nspname || '.' || cls.relname = ANY($1::text[])
	AND    array_length(con.conkey, 1) > 1`

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

	result := make(map[string][]CheckConstraint, len(tableNames))
	for rows.Next() {
		var tableName, constraintName, constraintDef string
		err = rows.Scan(&tableName, &constraintName, &constraintDef)
		if err != nil {
			return nil, err
		}
		// Normalize type casts for generic parser compatibility
		// PostgreSQL returns "::time without time zone" but the generic parser expects "::time"
		constraintDef = normalizePostgresTypeCasts(constraintDef)
		result[tableName] = append(result[tableName], CheckConstraint{
			Name:       NewIdentWithQuoteDetected(constraintName),
			Definition: constraintDef,
		})
	}
	return result, nil
}

func (d *PostgresDatabase) getUniqueConstraintsForTables(tableNames []string) (map[string]map[string]string, error) {
	const query = `SELECT nsp.nspname || '.' || cls.relname AS qualified_table_name, nsp.nspname, cls.relname, con.conname, pg_get_constraintdef(con.oid)