Reference
Version · 6.0
Change Automation Reference

typeAttribute

Last updated: August 12, 2026

The typeAttribute tag specifies information about attributes you create with the createCompositeType change type.

Available attributes

Name	Type	Description	Requirement
`name`	String	Name of the attribute	Required
`type`	String	Name of the type the attribute will be associated with	Required
collation	String	Name of an existing collation to be associated with a column of a composite type, or with a range type	Optional

typeAttribute examples

databaseChangeLog:
  - changeSet:
      id: 1
      author: itTest
      changes:
        - createCompositeType:
            typeName: "myType"
            typeAttributes:
              - typeAttribute:
                  name: "attr0"
                  type: "int"
              - typeAttribute:
                  name: "Attr1"
                  type: "int"
              - typeAttribute:
                  name: "ATTR2"
                  type: "text"
                  collation: "en_US"
              - typeAttribute:
                  name: "att®3"
                  type: "line"
              - typeAttribute:
                  name: "attribute 4"
                  type: "real"

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "itTest",
        "changes": [
          {
            "createCompositeType": {
              "typeName":"myType",
              "typeAttributes": [
                {
                  "typeAttribute": {
                    "name": "attr0",
                    "type": "int"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "Attr1",
                    "type": "int"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "ATTR2",
                    "type": "text",
                    "collation":"en_US"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "att®3",
                    "type": "line"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "attribute 4",
                    "type": "real"
                  }
                }
              ]
            }
          }
        ]
      }
    }
  ]
}

<?xml version="1.0" encoding="UTF-8"?>
						<databaseChangeLog
						xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
						xmlns:pro="http://www.liquibase.org/xml/ns/pro"
						xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
						xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
						http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">
						<changeSet author="itTest" id="1">
						<pro:createCompositeType typeName="myType">
						<pro:typeAttribute name="attr0" type="int"/>
						<pro:typeAttribute name="Attr1" type="int"/>
						<pro:typeAttribute name="ATTR2" type="text" collation="en_US"/>
						<pro:typeAttribute name="att®3" type="line"/>
						<pro:typeAttribute name="attribute 4" type="real"/>
						</pro:createCompositeType>
						</changeSet>
				</databaseChangeLog>

databaseChangeLog:
  - changeSet:
      id: 1
      author: itTest
      changes:
        - createCompositeType:
            typeName: "myType"
            typeAttributes:
              - typeAttribute:
                  name: "attr0"
                  type: "int"
              - typeAttribute:
                  name: "Attr1"
                  type: "int"
              - typeAttribute:
                  name: "ATTR2"
                  type: "text"
                  collation: "en_US"
              - typeAttribute:
                  name: "att®3"
                  type: "line"
              - typeAttribute:
                  name: "attribute 4"
                  type: "real"

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "itTest",
        "changes": [
          {
            "createCompositeType": {
              "typeName":"myType",
              "typeAttributes": [
                {
                  "typeAttribute": {
                    "name": "attr0",
                    "type": "int"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "Attr1",
                    "type": "int"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "ATTR2",
                    "type": "text",
                    "collation":"en_US"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "att®3",
                    "type": "line"
                  }
                },
                {
                  "typeAttribute": {
                    "name": "attribute 4",
                    "type": "real"
                  }
                }
              ]
            }
          }
        ]
      }
    }
  ]
}

<?xml version="1.0" encoding="UTF-8"?>
						<databaseChangeLog
						xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
						xmlns:pro="http://www.liquibase.org/xml/ns/pro"
						xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
						xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
						http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">
						<changeSet author="itTest" id="1">
						<pro:createCompositeType typeName="myType">
						<pro:typeAttribute name="attr0" type="int"/>
						<pro:typeAttribute name="Attr1" type="int"/>
						<pro:typeAttribute name="ATTR2" type="text" collation="en_US"/>
						<pro:typeAttribute name="att®3" type="line"/>
						<pro:typeAttribute name="attribute 4" type="real"/>
						</pro:createCompositeType>
						</changeSet>
				</databaseChangeLog>

PreviousCreateCompositeType NextDropCompositeType

typeAttribute

Available attributes

typeAttribute examples

YAML example

JSON example

XML example