Search Postgresql Archives

Re: Importing CSV File

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux