Re: How to import a CSV file (originally from Excel)

On Tue, 2006-04-11 at 23:13 +0200, Magnus Hagander wrote:
> > Hello,
> >
> > I am trying to import an Excel file in my database (8.0.7). I
> > think I am supposed to create an CSV file out of my Excel
> > file and somehow, feed the database with it. My pronblem is
> > that I don't really know how to do it... :( Can anyone give
> > me a hint about how to do that?
> > One last "detail", the Excel files contains roughly 45.000
> > lines and 15 columns. So, I need a fast and efficient method.
>
> Hi!
>
> Is your problem with how to generate the CSV file from Excel, or with
> how to import it into PostgreSQL?
>
> For generation in Excel, you can just use File->Save, and select CSV as
> the format. You can use either CSV or tab delimited, really.
>
> Then to get it into postgresql, use the \copy command in psql (I'm
> assuming your client is on windows, since you're using Excel. \copy will
> run the process from the client, and will load it into your sever
> regardless of platform). You can specify which delimiter to use there,
> etc. From the example below, I'd guess you want something along the line
> of:
>
> \copy "Flight Traffic" from yourfile.csv delimiter as ',' csv quote as
> '"'
>
> (might need some adaption, of course)
>
>
> Loading 45,000 lines is trivial for copy, it shouldn't take noticable
> time at all.
----
along these lines - can I do something similar (CSV file) but 'update' 2
or 3 columns?

Craig