Re: import content of XLS file into PostgreSQL

From: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: import content of XLS file into PostgreSQL
Date: 2007-08-06 11:11:31
Message-ID: C2DCC073.16A80%awitney@sgul.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I would like to know what should i do to import the content (not all columns)
> of a XLS file into pgsql.
> is there something special to do ?

Simplest way is to save it as a TAB delimited file and then look at the COPY
command? Or if it needs more complicated processing... you could write a
perl script to read the XLS file and insert the data from that

adam

In response to

Browse pgsql-general by date

  From Date Subject
Next Message novnov 2007-08-06 11:42:25 Re: Postgres 8.2 binary for ubuntu 6.10?
Previous Message Dave Page 2007-08-06 11:07:08 Re: Postgres service startup