Take a look at the sql COPY command (\h COPY) it will do it as you want
!
[EMAIL PROTECTED] 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
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