Take a look at the sql COPY command (\h COPY) it will do it as you want
!
Andrew.Mason@spektra.co.uk wrote:
>
> How should I go about importing the contents of an Excel spreadsheet
> into a Postgres database table?
>
> I was considering a comma separated file, but am not sure how to
> import this into the database.
>
> Are there any other suggestions?
>
> Thanks Andrew
>
