Skip to content
This repository has been archived by the owner on Sep 23, 2024. It is now read-only.

Allow transfer of PostgreSQL interval data type #190

Open
tonkas64 opened this issue Sep 10, 2022 · 0 comments
Open

Allow transfer of PostgreSQL interval data type #190

tonkas64 opened this issue Sep 10, 2022 · 0 comments
Labels
enhancement New feature or request

Comments

@tonkas64
Copy link

I have a dataset I need to transfer that includes the Postgres interval dataype, this doesn't appear to be currently supported.

I would like the interval type to be transfered as though it's a string/text type. My target (Redshift) can't store the interval type but can store the text and cast it back to interval.

My naive guess is this would 'just' be a change to discovery_utils.py

if data_type == 'interval':
        schema['type'] = nullable_column('string', col.is_primary_key)
        return schema
@tonkas64 tonkas64 added the enhancement New feature or request label Sep 10, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant