renameViewColumn

Last updated: June 9, 2026

The renameViewColumn change type renames a single column in a PostgreSQL view without modifying the view body. It is emitted automatically by diff-changelog when it detects a view column rename on PostgreSQL.

Note: Automatic rollback is supported. Liquibase reverses the rename by restoring the original column name.

Available attributes

Attribute	Type	Required	Description
`viewName`	String	Yes	Name of the view containing the column to rename.
`oldColumnName`	String	Yes	Current name of the column.
`newColumnName`	String	Yes	New name for the column.
`schemaName`	String	No	Name of the schema containing the view.
`catalogName`	String	No	Name of the catalog containing the view.

Example code

<?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/liquibase-latest.xsd
        http://www.liquibase.org/xml/ns/pro
        http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">

    <!-- Basic rename -->
    <changeSet id="1" author="your.name">
        <pro:renameViewColumn
            viewName="v_tour_summary"
            oldColumnName="tournumber"
            newColumnName="customertournumber"/>
    </changeSet>

    <!-- Rename with schema qualification -->
    <changeSet id="2" author="your.name">
        <pro:renameViewColumn
            viewName="v_tour_summary"
            oldColumnName="tournumber"
            newColumnName="customertournumber"
            schemaName="reporting"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumn": {
              "viewName": "v_tour_summary",
              "oldColumnName": "tournumber",
              "newColumnName": "customertournumber"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "2",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumn": {
              "viewName": "v_tour_summary",
              "oldColumnName": "tournumber",
              "newColumnName": "customertournumber",
              "schemaName": "reporting"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: 1
      author: your.name
      changes:
        - renameViewColumn:
            viewName: v_tour_summary
            oldColumnName: tournumber
            newColumnName: customertournumber

  - changeSet:
      id: 2
      author: your.name
      changes:
        - renameViewColumn:
            viewName: v_tour_summary
            oldColumnName: tournumber
            newColumnName: customertournumber
            schemaName: reporting

-- liquibase formatted sql

-- changeset your.name:1
ALTER VIEW public.v_tour_summary RENAME COLUMN tournumber TO customertournumber;

-- changeset your.name:2
ALTER VIEW reporting.v_tour_summary RENAME COLUMN tournumber TO customertournumber;

<?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/liquibase-latest.xsd
        http://www.liquibase.org/xml/ns/pro
        http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">

    <!-- Basic rename -->
    <changeSet id="1" author="your.name">
        <pro:renameViewColumn
            viewName="v_tour_summary"
            oldColumnName="tournumber"
            newColumnName="customertournumber"/>
    </changeSet>

    <!-- Rename with schema qualification -->
    <changeSet id="2" author="your.name">
        <pro:renameViewColumn
            viewName="v_tour_summary"
            oldColumnName="tournumber"
            newColumnName="customertournumber"
            schemaName="reporting"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumn": {
              "viewName": "v_tour_summary",
              "oldColumnName": "tournumber",
              "newColumnName": "customertournumber"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "2",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumn": {
              "viewName": "v_tour_summary",
              "oldColumnName": "tournumber",
              "newColumnName": "customertournumber",
              "schemaName": "reporting"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: 1
      author: your.name
      changes:
        - renameViewColumn:
            viewName: v_tour_summary
            oldColumnName: tournumber
            newColumnName: customertournumber

  - changeSet:
      id: 2
      author: your.name
      changes:
        - renameViewColumn:
            viewName: v_tour_summary
            oldColumnName: tournumber
            newColumnName: customertournumber
            schemaName: reporting

-- liquibase formatted sql

-- changeset your.name:1
ALTER VIEW public.v_tour_summary RENAME COLUMN tournumber TO customertournumber;

-- changeset your.name:2
ALTER VIEW reporting.v_tour_summary RENAME COLUMN tournumber TO customertournumber;

renameViewColumn

Available attributes

Example code

XML

JSON

YAML

SQL