Function GetTableDefinition

backend/plugin/schema/pg/get_database_definition.go:525–557

(schema string, table *storepb.TableMetadata, sequences []*storepb.SequenceMetadata)

}

func GetTableDefinition(schema string, table *storepb.TableMetadata, sequences []*storepb.SequenceMetadata) (string, error) {
	var buf strings.Builder
	if err := writeTable(&buf, schema, table, sequences); err != nil {
		return "", err
	}
	// Skip triggers, rules, and foreign keys for a table without column
	// metadata; their definitions can reference the missing columns.
	if tableMissingColumnMetadata(table) {
		return buf.String(), nil
	}
	// Construct triggers.
	for _, trigger := range table.Triggers {
		if trigger.SkipDump {
			continue
		}
		if err := writeTrigger(&buf, schema, table.Name, trigger); err != nil {
			return "", err
		}
	}
	// Construct rules.
	if len(table.Rules) > 0 {
		if err := writeRules(&buf, schema, table.Name, table.Rules); err != nil {
			return "", err
		}
	}
	// Construct foreign keys.
	for _, fk := range table.ForeignKeys {
		if err := writeForeignKey(&buf, schema, table.Name, fk); err != nil {
			return "", err
		}
	}
	return buf.String(), nil
}

func GetViewDefinition(schema string, view *storepb.ViewMetadata) (string, error) {
	var buf strings.Builder