Skip to content

Generated syntax for comment in table creation is incorrect #2122

@henriqueNev

Description

@henriqueNev

Description

When copying the table creation script and trying to execute it in another database, the following error occurs:
/* ERROR: syntax error at or near "COMMENT" LINE 9: COMMENT ON TABLE
Image

In the image below, I show the incorrect syntax that HeidiSQL is generating, and also the correct syntax:
Image

HeidiSQL version

12.6.0.6765

Database server version

PostgreSQL 15

Reproduction recipe

As per the image below:
Image

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLnettype-postgresqlPostgreSQL specific issue

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions