search

psequel / psequel

Free PostgreSQL GUI tool for macOS.
http://www.psequel.com/
563 stars 7 forks source link

CSV Imports #129

Open s2t2 opened 8 years ago

s2t2 commented 8 years ago

As a user, in order to create a new table from the contents of a csv file, I should be able to use an import wizard.

houshuang commented 7 years ago

This would be great. It's not too difficult to use the COPY command, but if it could also auto-generate a schema definition (which you could modify before running), that would save a ton of time. I often import CSV or JSON files into Postgres for analysis. There are also command line tools like pgimport, but I always have to look up the parameters etc.

psequel commented 7 years ago

Currently PSequel focuses on making it easy to do repetitive tasks, which mean table viewing and editing. It's not trying to replace pgAdmin 3. Instead, it's designed to be supplementary to pgAdmin 3. For importing CSV files, which most users don't need to do very often, I'd suggest you to use pgAdmin 3. This feature might be implemented in PSequel in distant future.

s2t2 commented 6 years ago

Coming back to desiring this same feature, almost two years later.

I encourage you to implement this feature. It would be nice to have an alternative to Pg Admin. 😸