Skip to content

PostgreSQL - generated syntax for table creation is incorrect #2122

Open
@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

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions