Re: Bulk CSV input within the GUI, not from file? - Mailing list pgadmin-support

From richard coleman
Subject Re: Bulk CSV input within the GUI, not from file?
Date
Msg-id CAGA3vBvoj5kq8KXYP9R6N0Mmq4s7zs-5rPK425Y2i7=kV6ne-A@mail.gmail.com
Whole thread Raw
In response to Bulk CSV input within the GUI, not from file?  (Jeong-hun Sin <typingcat@gmail.com>)
List pgadmin-support
Jeong-hun Sin, 

Have you tried just writing one or more INSERT statements in the query tool?  In that way you won't need a CSV file and can just type them in the text area as opposed to the data grid.

I hope that helps,

rik.

On Sat, Jun 11, 2022 at 7:18 PM Jeong-hun Sin <typingcat@gmail.com> wrote:
I wanted to input some 10 tuples into a simple table. I thought I could do that in a spreadsheet-like GUI as in MS SQL Management Studio, but the UI of PGAdmin was a lot more inconvenient. I looked around and found that it has an "import data" feature.  CSV was good-enough but it required the CSV to be a file. Can't pgAdmin have a textarea that allows users to type or paste CSV directly without using a file? I mean, creating a temporary CSV file and selecting the file in pgAdmin was not that convenient because pgAdmin's file browser dialogue is not as good as the OS native version.

pgadmin-support by date:

Previous
From: Jeong-hun Sin
Date:
Subject: Bulk CSV input within the GUI, not from file?
Next
From: Francis DAGUENE
Date:
Subject: Installation Windows 10