Method exportTableDDL

database/postgres/database.go:734–764

(table string, cache *TableDDLComponentsCache)

}

func (d *PostgresDatabase) exportTableDDL(table string, cache *TableDDLComponentsCache) (string, error) {
	components := TableDDLComponents{
		TableName:     table,
		DefaultSchema: d.GetDefaultSchema(),
	}

	components.Columns = cache.columns[table]
	components.PrimaryKeyCols = cache.primaryKeyCols[table]
	// if pkey cols exist, retrieve the pkey name
	if len(components.PrimaryKeyCols) > 0 {
		pkInfo, ok := cache.primaryKeyInfos[table]
		if !ok {
			return "", fmt.Errorf("failed to get primary key name for table %s", table)
		}
		components.PrimaryKeyName = pkInfo.name
		components.PrimaryKeyPeriod = pkInfo.period
	}
	components.IndexDefs = cache.indexDefs[table]
	components.ForeignDefs = cache.foreignDefs[table]
	components.RLSDefs = cache.rlsDefs[table]
	components.PolicyDefs = cache.policyDefs[table]
	components.CheckConstraints = cache.checkConstraints[table]
	components.UniqueConstraints = cache.uniqueConstraints[table]
	if components.UniqueConstraints == nil {
		components.UniqueConstraints = make(map[string]string)
	}
	components.ExclusionDefs = cache.exclusionDefs[table]
	components.Comments = cache.comments[table]
	components.PrivilegeDefs = cache.privilegeDefs[table]
	return d.buildExportTableDDL(components), nil
}

func (d *PostgresDatabase) buildExportTableDDL(components TableDDLComponents) string {
	var queryBuilder strings.Builder