[Bug]: psql/schema.sql is actually MySQL

[leonard2901]

Issue Type

API/Export Issue

Location (if applicable)

No response

What's wrong?

The file psql/schema.sql contains a dump from MySQL.

What should it be?

A PostgreSQL dump like the other files

Source (optional)

No response

[dosubot]

Hi @leonard2901! I'm Dosu and I’m helping the countries-states-cities-database team.

psql/schema.sql currently contains a MySQL schema dump, not a PostgreSQL one, due to the export workflow using mysqldump for all schema.sql files—even in the psql directory. This is confirmed by the workflow config and recent export pull requests, which show MySQL-specific syntax in psql/schema.sql, while the other psql/.sql files (like psql/countries.sql, psql/regions.sql, psql/world.sql) are proper PostgreSQL dumps generated with pg_dump. There are no existing tickets or fixes for this issue as of the latest exports. If you need a true PostgreSQL schema, use the other psql/.sql files or update the export workflow to generate psql/schema.sql with pg_dump instead of mysqldump.

See supporting details in the export workflow and recent export PRs.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

   

[leonard2901]

If this is indeed intentional I would argue that it's not helpful or at least confusing.