Secure 6.0: renameViewColumnsAndUpdateBody

Reference
Version · 6.0
Change Automation Reference

renameViewColumnsAndUpdateBody

Last updated: September 29, 2026

The renameViewColumnsAndUpdateBody change type renames one or more columns in a PostgreSQL view and simultaneously updates the view body SQL. It is emitted automatically by diff-changelog when it detects view column renames paired with a body change on PostgreSQL.

Note: Automatic rollback is supported. Liquibase reverses each column rename and restores the original view body SQL. When the restored body has fewer columns than the current view, Liquibase drops and recreates the view instead of replacing it, because PostgreSQL cannot remove columns with CREATE OR REPLACE VIEW. Rollback requires oldBody.

Available attributes

Attribute	Type	Required	Description
`viewName`	String	Yes	Name of the view to update.
`oldColumnNames`	String	Yes	Comma-separated list of current column names to rename.
`newColumnNames`	String	Yes	Comma-separated list of new column names, in the same order as oldColumnNames.
`oldBody`	String	No	The previous view body SQL. Required for rollback; omit only if you will not roll back this changeset.
`newBody`	String	Yes	The new view body SQL to apply.
`recreateView`	String	No	Direction in which the view's column set shrinks, which requires DROP VIEW and CREATE VIEW instead of CREATE OR REPLACE VIEW. Set to FORWARD when applying the changeset shrinks the view, or ROLLBACK when rolling it back does. diff-changelog sets this automatically. Omit it when the column count does not change.
`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">

    <!-- Single rename with body update -->
    <changeSet id="1" author="your.name">
        <pro:renameViewColumnsAndUpdateBody
            viewName="v_tour_summary"
            oldColumnNames="tournumber"
            newColumnNames="customertournumber"
            oldBody="SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody="SELECT id, tour_number AS customertournumber, customer_name FROM tours"/>
    </changeSet>

    <!-- Two renames with body update -->
    <changeSet id="2" author="your.name">
        <pro:renameViewColumnsAndUpdateBody
            viewName="v_tour_summary"
            oldColumnNames="tournumber,customer_name"
            newColumnNames="customertournumber,clientname"
            oldBody="SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody="SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours"
            schemaName="reporting"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumnsAndUpdateBody": {
              "viewName": "v_tour_summary",
              "oldColumnNames": "tournumber",
              "newColumnNames": "customertournumber",
              "oldBody": "SELECT id, tour_number AS tournumber, customer_name FROM tours",
              "newBody": "SELECT id, tour_number AS customertournumber, customer_name FROM tours"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "2",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumnsAndUpdateBody": {
              "viewName": "v_tour_summary",
              "oldColumnNames": "tournumber,customer_name",
              "newColumnNames": "customertournumber,clientname",
              "oldBody": "SELECT id, tour_number AS tournumber, customer_name FROM tours",
              "newBody": "SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours",
              "schemaName": "reporting"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: 1
      author: your.name
      changes:
        - renameViewColumnsAndUpdateBody:
            viewName: v_tour_summary
            oldColumnNames: tournumber
            newColumnNames: customertournumber
            oldBody: "SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody: "SELECT id, tour_number AS customertournumber, customer_name FROM tours"

  - changeSet:
      id: 2
      author: your.name
      changes:
        - renameViewColumnsAndUpdateBody:
            viewName: v_tour_summary
            oldColumnNames: "tournumber,customer_name"
            newColumnNames: "customertournumber,clientname"
            oldBody: "SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody: "SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours"
            schemaName: reporting

-- liquibase formatted sql

-- changeset your.name:1
ALTER VIEW public.v_tour_summary RENAME COLUMN tournumber TO customertournumber;
CREATE OR REPLACE VIEW public.v_tour_summary AS SELECT id, tour_number AS customertournumber, customer_name FROM tours;

-- changeset your.name:2
ALTER VIEW reporting.v_tour_summary RENAME COLUMN tournumber TO customertournumber;
ALTER VIEW reporting.v_tour_summary RENAME COLUMN customer_name TO clientname;
CREATE OR REPLACE VIEW reporting.v_tour_summary AS SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours;

<?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">

    <!-- Single rename with body update -->
    <changeSet id="1" author="your.name">
        <pro:renameViewColumnsAndUpdateBody
            viewName="v_tour_summary"
            oldColumnNames="tournumber"
            newColumnNames="customertournumber"
            oldBody="SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody="SELECT id, tour_number AS customertournumber, customer_name FROM tours"/>
    </changeSet>

    <!-- Two renames with body update -->
    <changeSet id="2" author="your.name">
        <pro:renameViewColumnsAndUpdateBody
            viewName="v_tour_summary"
            oldColumnNames="tournumber,customer_name"
            newColumnNames="customertournumber,clientname"
            oldBody="SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody="SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours"
            schemaName="reporting"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumnsAndUpdateBody": {
              "viewName": "v_tour_summary",
              "oldColumnNames": "tournumber",
              "newColumnNames": "customertournumber",
              "oldBody": "SELECT id, tour_number AS tournumber, customer_name FROM tours",
              "newBody": "SELECT id, tour_number AS customertournumber, customer_name FROM tours"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "2",
        "author": "your.name",
        "changes": [
          {
            "renameViewColumnsAndUpdateBody": {
              "viewName": "v_tour_summary",
              "oldColumnNames": "tournumber,customer_name",
              "newColumnNames": "customertournumber,clientname",
              "oldBody": "SELECT id, tour_number AS tournumber, customer_name FROM tours",
              "newBody": "SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours",
              "schemaName": "reporting"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: 1
      author: your.name
      changes:
        - renameViewColumnsAndUpdateBody:
            viewName: v_tour_summary
            oldColumnNames: tournumber
            newColumnNames: customertournumber
            oldBody: "SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody: "SELECT id, tour_number AS customertournumber, customer_name FROM tours"

  - changeSet:
      id: 2
      author: your.name
      changes:
        - renameViewColumnsAndUpdateBody:
            viewName: v_tour_summary
            oldColumnNames: "tournumber,customer_name"
            newColumnNames: "customertournumber,clientname"
            oldBody: "SELECT id, tour_number AS tournumber, customer_name FROM tours"
            newBody: "SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours"
            schemaName: reporting

-- liquibase formatted sql

-- changeset your.name:1
ALTER VIEW public.v_tour_summary RENAME COLUMN tournumber TO customertournumber;
CREATE OR REPLACE VIEW public.v_tour_summary AS SELECT id, tour_number AS customertournumber, customer_name FROM tours;

-- changeset your.name:2
ALTER VIEW reporting.v_tour_summary RENAME COLUMN tournumber TO customertournumber;
ALTER VIEW reporting.v_tour_summary RENAME COLUMN customer_name TO clientname;
CREATE OR REPLACE VIEW reporting.v_tour_summary AS SELECT id, tour_number AS customertournumber, customer_name AS clientname FROM tours;

PreviousRenameViewColumn NextAbortWarehouseQueries

renameViewColumnsAndUpdateBody

Available attributes

Example code

XML

JSON

YAML

SQL