jakob / jakob/Postico

Importing CSV from a Postico CSV export keeps failing

Open
#789 4 comments 2 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.