Insert from CSV (comma separated values) file ?

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Insert from CSV (comma separated values) file ?
Date: 2003-01-16 21:51:30
Message-ID: 20030116.Taq.79021600@192.168.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Nelson 2003-01-16 22:03:37 Upgrading
Previous Message Bruno Wolff III 2003-01-16 21:21:58 Re: three timestamps/table, use of 'now' in table creation statement