Postgres Pro
Downloads
Home   >   mailing lists

Re: Importing CSV File - Mailing list pgsql-general

From Rajeev Bhatta
Subject Re: Importing CSV File
Date
Msg-id 747ACC5A-B6CB-4D1C-8BAD-870EC568D3E1@yahoo.in
Whole thread Raw
In response to Re: Importing CSV File  (David Blomstrom <david.blomstrom@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: "657985552@qq.com"
Date:
Subject: 回复: postgres cpu 100% need help
Next
From: "David G. Johnston"
Date:
Subject: Re: Recursive Arrays 101