jakob / jakob/Postico

Export using SQL insert

Open
#36 55 comments 41 reactions 0 assignees View on GitHub
enhancement maybe-later
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Would be great to be able to export a table using SQL inserts. Right now only CSV seems to be available. Copy Special is great, but works only for the selected rows, not for whole tables.

Or if SQL inserts are hard to implement, perhaps just importing CSV would be nice.
How I do it now: `COPY table FROM 'xxxx.csv' DELIMITER ',' CSV;`

Contributor guide

No contributing guide indexed for this repository

Research direction

No files or tests are named. Start by locating the existing CSV export and Copy Special entry points, then clarify whether whole-table SQL INSERT export or CSV import is the intended scope. Done means the selected operation works for an entire table, not only selected rows, with behavior covered by an appropriate test or manual check.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python, sql
Domain
database, desktop
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.