How to remove MySQL defaults that aren't valid PostgreSQL?

[marshallm94]

Is there a way to remove defaults for columns, similar to pgloader's CAST argument?

For example, I have a load file (pgloader's input) that looks like this:

LOAD DATABASE
  FROM mysql://root:XXXXXXXXXXXXXXX@localhost:3306/Stocks
  INTO postgresql://root:XXXXXXXXXXXXXXX@localhost:5432/Stocks

CAST
  type datetime when default 'utc_timestamp()' to "timestamptz default timezone('utc', now())" drop default,
  type float to numeric,
  type bigint when (= precision 20) to bigint drop typemod
;

The second line in the CAST clause could be configured in the data_types_map.json, but is there a way to configure the first line?

Thanks

[AnatolyUss]

Hello Marshall, Currently, there's no way to configure constraints/default removal.

…

On Thu, Sep 5, 2024, 2:05 PM Marshall McQuillen ***@***.***> wrote: Is there a way to remove defaults for columns, similar to pgloader's CAST argument <https://pgloader.readthedocs.io/en/latest/ref/mysql.html#mysql-database-casting-rules> ? For example, I have a load file (pgloader's input) that looks like this: LOAD DATABASE FROM ***@***.***:3306/Stocks INTO ***@***.***:5432/Stocks CAST type datetime when default 'utc_timestamp()' to "timestamptz default timezone('utc', now())" drop default, type float to numeric, type bigint when (= precision 20) to bigint drop typemod ; The second line in the CAST clause could be configured in the data_types_map.json, but is there a way to configure the first line? Thanks — Reply to this email directly, view it on GitHub <#132>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADHR7N7CJE2SSYTBIXQI6IDZVA3GHAVCNFSM6AAAAABNWHPOXWVHI2DSMVQWIX3LMV43ASLTON2WKOZSGUYDONBXGEYTCMI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>