Skip to content

PostgreSQL SQL export with unsupported SHOW CREATE DATABASE #2013

Closed as duplicate

Description

@kyesil

Description

What where you trying to do?

connectiing PostgreSQL 16 server like:
image

What actually happened?

Exporting all tables in my project like:
image
Error : ERROR: syntax error at or near "CREATE"LINE 1: SHOW CREATE DATABASE "public"

What did you expect to happen?

Dump all tables to sql file

HeidiSQL version

12.8

Database server version

Postgresql 16.4

Error/Backtrace

No response

Reproduction recipe

connect postgresql 16 db
export all tables as sql file

Activity

  1. added
    bugDefective behaviour in HeidiSQL
    on Aug 27, 2024
  2. changed the title [-]PostgreSQL 16 support[/-] [+]PostgreSQL SQL export with unsupported SHOW CREATE DATABASE[/+] on Aug 28, 2024
  3. ansgarbecker commented on Aug 28, 2024

    @ansgarbecker
    Collaborator

    Related to #1031 and #1100

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 HeidiSQLnettype-postgresqlPostgreSQL specific issue

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions