From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Aren Cambre <aren(at)arencambre(dot)com> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Pasting of Excel data into tables |
Date: | 2012-02-22 20:48:30 |
Message-ID: | aa6755f105ed829650f00a7d3682ee3f@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Wed, 22 Feb 2012 14:37:02 -0600, Aren Cambre <aren(at)arencambre(dot)com>
wrote:
> Is it possible to paste Excel data into tables, presuming the data and
> structure is similar to the Postgres table?
Nope.
> It looks like I ought to be able to paste copied data into the Edit Data
> dialog, but that paste only ends up in one cell. E.g., if I have a table
> with 5 columns, and I copy a 5 col x 1000 row Excel spreadsheet and then
> paste it into the row in Edit Data marked *, all the data goes into the
> first cell.
The "Edit Data" window misses some interesting features, I totally agree.
Right now, if you paste something, it goes into one cell.
> I'm asking because if this doesn't work, looks like I need to do an
> import from CSV. That's not the end of the world, but it's much less
> convenient than copy-paste, which works in some other apps.
You'll need to do an import from CSV. The new tool I'm working on will
make it easier to import a CSV file.
To go further, we would need to find someone motivated to work on the
"Edit Data" window.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2012-02-22 21:36:25 | pgAdmin object tree still breaks on reconnect to DB |
Previous Message | Aren Cambre | 2012-02-22 20:37:02 | Pasting of Excel data into tables |