Export table from mariaDB to Postgres, tables and columns become lower case (MariaDB)

[symdeb]

Description

Export a table from mySQL with columns and table names in uppercase
Uuse Postgres schema as target
The table name is fixed to lower case.
in the preview columns are shown as uppercase, but actual creation is postgres lowercase
it seem there is no option to change this.

DBeaver Version

26.0

Operating System

Ubuntu 26.10

Database and driver

1. MySQL => Actually MARIADB
2. Postgres

Steps to reproduce

As above

Additional context

No response

[davestokes]

@symdeb Thank you for your report.

[davestokes]

@symdeb What version of MariaDB are you using? If I set the connection settings Emtadata to use case-sensitive names in DDL statements, the case sensitivity is upheld. Not the case with MySQL.

If I export to INSERT statements, the case sensitivity is kept.

[symdeb]

Export upper case names table and columns to CSV
Import dialog shows table lower case and cannot be changed (customized)
after import all data is lowercase
11.8.3-MariaDB-1build1 from Ubuntu

For another table the data columns were uppercase, but table name fixed to lower.

in connection settings,found the settings and change to upper case.
Still not sure why in other other export/import the columns were lower case.

[E1izabeth]

@symdeb, you can change the target table and column names at this step

If you want the case to be preserved, put it to quotes.