Skip to content

Support COMMENT ON syntax in Postgres #2129

Closed
@1ilit

Description

@1ilit

Describe the bug
The parser throws a syntax error when it gets to ON. It would be great if it recognized comments.

Database Engine
PostgreSQL

To Reproduce
-the SQL that be parsed

COMMENT ON TABLE users IS 'users table';
COMMENT ON TABLE "users" IS 'users table';
COMMENT ON COLUMN users.name IS 'first name and last name';
COMMENT ON COLUMN "users"."name" IS 'first name and last name';

-the node-sql-parser version
v5.3.2
-the node version
v18.20.3

Expected behavior
Output the ast

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions