Insert from CSV (comma separated values) file - Mailing list pgsql-novice

From Brian Johnson
Subject Insert from CSV (comma separated values) file
Date
Msg-id 20030115.Q6h.21925800@192.168.0.1
Whole thread Raw
Responses Re: Insert from CSV (comma separated values) file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I need to insert some values from a CSV file.  It's a little more complicated than
that since I have to do a SELECT query (from one table) on one of the values to get
the proper value for the INSERT query (into another table)

I'd like it to be some kind of script that I could set up as a cron job

This sounds like the kind of things that somebody may have already done - can
anyone point me to it?  I'd prefer bash or perl scripts

I checked google but couldn't come up with anything


pgsql-novice by date:

Previous
From: "Devinder K Rajput"
Date:
Subject: Re: reading command from file
Next
From: Tom Lane
Date:
Subject: Re: Insert from CSV (comma separated values) file