Re: Bulk CSV input within the GUI, not from file?

Поиск
Список
Период
Сортировка
От richard coleman
Тема Re: Bulk CSV input within the GUI, not from file?
Дата
Msg-id CAGA3vBvoj5kq8KXYP9R6N0Mmq4s7zs-5rPK425Y2i7=kV6ne-A@mail.gmail.com
обсуждение исходный текст
Ответ на Bulk CSV input within the GUI, not from file?  (Jeong-hun Sin <typingcat@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeong-hun Sin
Дата:
Сообщение: Bulk CSV input within the GUI, not from file?
Следующее
От: Francis DAGUENE
Дата:
Сообщение: Installation Windows 10