Re: Importing CSV File

Поиск
Список
Период
Сортировка
От Rajeev Bhatta
Тема Re: Importing CSV File
Дата
Msg-id 747ACC5A-B6CB-4D1C-8BAD-870EC568D3E1@yahoo.in
обсуждение исходный текст
Ответ на Re: Importing CSV File  (David Blomstrom <david.blomstrom@gmail.com>)
Список pgsql-general
You could do it simpler by creating a temp table with all columns in the CSV and then doing either creating another table of the temp table or building a view on top of the table.

The decision depends on how frequently you would be importing data from the CSV. If only one time then you are better off doing it through a spreadsheet.

Thanks
Rajeev

On October 27, 2015 4:49:22 AM GMT+05:30, David Blomstrom <david.blomstrom@gmail.com> wrote:
Wow, I must be getting dyxlexic; yes, it is 

\r\n


I guess it would be easy enough to just copy the stuff I want to import into a separate spreadsheet and save it as a CSV. I've done that before with really big spreadsheets, actually. Thanks.

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

В списке pgsql-general по дате отправления:

Предыдущее
От: "657985552@qq.com"
Дата:
Сообщение: 回复: postgres cpu 100% need help
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Recursive Arrays 101