| From: | Rajeev Bhatta <techie(dot)rajeev(at)yahoo(dot)in> |
|---|---|
| To: | David Blomstrom <david(dot)blomstrom(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Importing CSV File |
| Date: | 2015-10-27 04:37:25 |
| Message-ID: | 747ACC5A-B6CB-4D1C-8BAD-870EC568D3E1@yahoo.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)blomstrom(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2015-10-27 12:46:50 | Re: Recursive Arrays 101 |
| Previous Message | 657985552@qq.com | 2015-10-27 03:30:45 | 回复: postgres cpu 100% need help |