Column comment on late binding view ("NO SCHEMA BINDING") not possible

0

For our database documentation we would like to add comments to columns in different views. Most of those views are currently late-binding views.

Example for a late binding view:

CREATE OR REPLACE VIEW schema.view
AS
SELECT table."Col1", table."Col2"
FROM schema.table
WITH NO SCHEMA BINDING;

When trying to add a column comment to a late binding view by

COMMENT ON COLUMN schema.view."Col1" IS 'Some useful information';

we get the following error message: "Column "Col1" of relation "table" does not exist;"

Any advice on how to add comments on late binding views?

Thank you!

질문됨 일 년 전368회 조회
1개 답변
0

Are quotation marks necessary?
I felt it would work in the following way.

COMMENT ON COLUMN schema.view.Col1 IS 'Some useful information';
profile picture
전문가
답변함 일 년 전
  • Thank you for your answer!

    The quotation marks are not strictly necessary. Only in the case of case sensitive data it's relevant. Leaving them away does not change the behavior unfortunately...

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠