sql - 使用评论在 postgresql 中创建 View

Question

我用sql语句在postgres sql中创建一个 View

CREATE OR REPLACE VIEW  {ViewName} as 
Select
.....

我想问有没有什么方法可以为 View 中的列创建注释。创建 View 后，在向列添加注释时会生成错误:

ERROR: "{ViewName}" is not a table, composite type, or foreign table.

Answer 1

要在列(或 View )上定义注释，请使用 comment on :

create view some_view
as
select x as col1, y as col2, z as col3
from some_table;

然后:

comment on view some_view is 'Some View';
comment on column some_view.col1 is 'Originally column X';