renameViewColumnsAndUpdateBody

Last updated: June 9, 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.

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	Yes	The current view body SQL (used for rollback).
`newBody`	String	Yes	The new view body SQL to apply.
`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, 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, 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, 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, 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, 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, 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;

renameViewColumnsAndUpdateBody

Available attributes

Example code

XML

JSON

YAML

SQL