Insert from CSV (comma separated values) file

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Insert from CSV (comma separated values) file
Date: 2003-01-16 03:50:40
Message-ID: 20030115.Q6h.21925800@192.168.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-01-16 05:14:07 Re: Insert from CSV (comma separated values) file
Previous Message Jeffrey Melloy 2003-01-16 00:58:26 Re: reading command from file