Importing CSV from a Postico CSV export keeps failing
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
## What did you do?
- Exported a table from a production db to csv via Postico
- In a different local development db, I attempted to import the same csv into the same table
## What did you expect to happen?
- I expected to see the table import successfully.
## What actually happened?
- I received an error 'PostgreSQL said: syntax error at or near ";"' and the import failed.'
## What software versions are you using?
Postico version:
1.5.19 (previously used and tried 1.5.8, same result)
macOS version:
Big sur 11.6
PostgreSQL version:
11.6
Context: I also tried validating the csv file using some online validators and didn't find any issues. It's quite a large csv file so searching for a syntax error is not feasible.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the import with the Postico CSV export against PostgreSQL 11.6, then isolate the generated SQL near the reported semicolon syntax error. Done means the exported CSV imports successfully into the matching local table without the syntax error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100