Pasting of Excel data into tables - Mailing list pgadmin-support

From Aren Cambre
Subject Pasting of Excel data into tables
Date
Msg-id CAA1mBro2jP-0-io_9YcPjHOsezXjnQcj-ZGEsBN5ZJf-4k1zPQ@mail.gmail.com
Whole thread Raw
Responses Re: Pasting of Excel data into tables
List pgadmin-support
Is it possible to paste Excel data into tables, presuming the data and structure is similar to the Postgres table?

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.

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.

Aren

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Trigger Script Error
Next
From: Guillaume Lelarge
Date:
Subject: Re: Pasting of Excel data into tables