Re: how to copy data from excel spreadsheet to postgresql database

pgsql-bugs(at)postgresql(dot)org wrote:

> Martin Kuria (martinkuria(at)hotmail(dot)com) reports a bug with a severity of 1
> The lower the number the more severe it is.

Bug? severe?
But I will undertake to answer you though.

> Short Description
> how to copy data from excel spreadsheet to postgresql database
>
> Long Description
> I have enter data in excel spreadsheet, and I would like to enter or copy this data in my postgresql database, please do give a example, thanks
>
> best regards
> martin.
>
> Sample Code
> explain more on how how a copy command is used, please illustrate with an example
>
> No file was uploaded with this report

Do you know SQL? If not, read Bruce's Book.
Export as ASCII, seperated by TABS.
Then precede it by 'copy yourtable from stdin;'
Add '\.' as the last line.
Feed it into postgres:
psql <yourfile yourdatabase

Yours
Christof