Skip to content

Request: Posgresql COMMENT ON syntax support #2073

Closed
@hhlong87

Description

@hhlong87

Describe the bug
COMMENT ON [something] syntax
https://www.postgresql.org/docs/current/sql-comment.html

Database Engine
PostgreSQL

To Reproduce
-the SQL that be parsed: COMMENT ON COLUMN test_table.status IS 'new comment';
-the node-sql-parser 5.3.0
-the node version: 20.11.0
-error: SyntaxError: Expected "--", "/*", ":=", "=", "FOR", "TO", or [ \t\n\r] but "o" found. near 'on' at line 1

Expected behavior
Should be able to parse. Some common used like ON COLUMN, ON INDEX, ON TABLE, ON CONSTRAINT is ok.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions