Thread

1. how to copy data from excel spreadsheet to postgresql database

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-09-28T08:00:29Z

   Martin Kuria (martinkuria@hotmail.com) reports a bug with a severity of 1
   The lower the number the more severe it is.
   
   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
   
   
   

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

   Christof Petig <christof.petig@wtal.de> — 2000-09-29T17:21:55Z

   pgsql-bugs@postgresql.org wrote:
   
   > Martin Kuria (martinkuria@hotmail.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