On Wed, Mar 8, 2017 at 8:45 AM, vinny <vinny@xs4all.nl> wrote:
On 2017-03-08 10:13, Günce Kaya wrote:
Hi all,
I want to import content of CSV file to a table via bash script without creating temporary table and I also want to skip some columns in CSV file (for instance, CSV file has 12 column and main table has only 2 column, If possible I would use only 2 column in CSV file) Is there any way to do it?
Regards,
--
Gunce Kaya
This is more a programming question than a database question, and there are many possible solutions. Do *not*, whatever you do, try to write your own piece of code to read the CSV. There are lots of unexpected ways that the CSV file can be slightly different from what you expect, and figuring all those out is a waste of time. The example of embedded comma's is just one way, there could also be newlines, linebreaks, utf8-escape characters etc.
Personally I'd go the python route because it's simple and straightforward, but anything you are comfortable with will do. If you are going to install additional software to do this then remember that you'll need that same software again if you need to do this again, or when you need to move this code to a different server.
I agree. I went with a "pure BASH" approach because it is what the user asked for & I wasn't sure what language she might be comfortable with. I use PERL a lot. Or maybe I should say that I abuse PERL a lot. Such as a PERL script with writes out another PERL script, based on some input files & parameters, then runs the just written PERL script, which does the load into a PostgreSQL database (multiple tables). Ya, a bit perverted.
--
"Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion