Allow ALTER VIEW command to rename the column in the view

Enterprise / PostgreSQL - Fujii Masao [postgresql.org] - 21 November 2019 10:55 EST

ALTER TABLE RENAME COLUMN command always can be used to rename the column in the view, but it's reasonable to add that syntax to ALTER VIEW too.

Author: Fujii Masao

30840c92ac Allow ALTER VIEW command to rename the column in the view.
doc/src/sgml/ref/alter_view.sgml | 19 +++++++++++++++++++
src/backend/commands/view.c | 3 ++-
src/backend/parser/gram.y | 22 ++++++++++++++++++++++
src/bin/psql/tab-complete.c | 14 +++++++++++++-
src/test/regress/expected/create_view.out | 27 ++++++++++++++++++++++++++-
src/test/regress/sql/create_view.sql | 6 ++++++
6 files changed, 88 insertions(+), 3 deletions(-)

Upstream: git.postgresql.org


  • Share