Skip to content

HeidiSQL can't export Postgresql database with including option "Create Database" #2581

Open

Description

@childonline

Description

Image

HeidiSQL version and OS

Win11

Database server version

12.16.0.7229

Reproduction recipe

try to export any pgsql table via table tools

Error/Backtrace

Activity

  1. childonline commented on Aug 20, 2026

    @childonline
    Author

    updated to 12.21.0.7344, same issue. export doesn't work, no matter what i choose in "Output:", no matter what i choose in "Data:", no matter if i choose to drop and/or create

    Image
  2. ansgarbecker commented on Aug 25, 2026

    @ansgarbecker
    Collaborator

    Yes the export feature is quite MySQL-only and does not work stable for any other dbms. Especially the structure/DDL queries depend on MySQL syntax yet. Also reported in #1031 and #1100

  3. ansgarbecker commented on Aug 25, 2026

    @ansgarbecker
    Collaborator

    Perhaps I can at least fix the database creation for all non-mysql systems. There are surely more errors but this one is a good starting point. Already has another duplicate in #2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membernettype-postgresqlPostgreSQL specific issue

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions