dolthub / dolthub/dolt-workbench

File upload for postgres databases does not let user specify duplicate key behavior

Open
#85 0 comments 0 reactions 0 assignees View on GitHub
enhancement postgres
Dominant language
TypeScript
Stars
246
Forks
29
Avg merge
9h 13m
Merged PRs (30d)
9

Description

MySQL file upload uses a [`LOAD DATA`](https://dev.mysql.com/doc/refman/8.0/en/load-data.html) statement to import file data into a table. It lets you specify whether you'd like to `ignore` or `replace` on duplicate key.

Postgres file upload uses a [`COPY FROM`](https://www.postgresql.org/docs/current/sql-copy.html) statement. It does not let you specify duplicate key behavior. There are workarounds like [this](https://stackoverflow.com/a/13949654/10555434), where we can import to a temporary table, and then specify on conflict behavior on upsert

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.