这是indexloc提供的服务,不要输入任何密码
Skip to content

SQL tab of view with field comments contains "comment on column" statements without quotes #6280

@kraynopp

Description

@kraynopp

SQL tab of view contains following:

CREATE OR REPLACE VIEW public.testviewcomments
AS
SELECT testtablecomments.field
FROM testtablecomments;
ALTER TABLE public.testviewcomments
OWNER TO postgres;
COMMENT ON VIEW public.testviewcomments
IS 'View comment';
COMMENT ON COLUMN public.testviewcomments.field
IS Field comment;

But the last statement should be:
COMMENT ON COLUMN public.testviewcomments.field
IS 'Field comment';

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions