RE: Importing Excel Spreadsheets into PostgreSQL

From: Francisco Reyes <fran(at)reyes(dot)somos(dot)net>
To: Ben Hooper <Ben(dot)Hooper(at)diskcopy(dot)com(dot)au>
Cc: PostgreSQL Novice Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Importing Excel Spreadsheets into PostgreSQL
Date: 2001-02-02 05:25:45
Message-ID: Pine.BSF.4.32.0102020024360.1877-100000@zoraida.reyes.somos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> After a few dozen combinations I was able to answer my own question.
> 1. Save the Excel spreadsheet as comma delimited.
> 2. run 'psql mydatabase'
> 3. run 'COPY mytable FROM '/myfile.csv' USING DELIMITERS ',';
> and it works!

I am new to PostgreSQL myself, but from the little I have seen Pgsql uses
tabs as it's native separator. In other words if you can save that ascii
file using tabs as a separator you won't need to add a DELIMITERS clause.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Reyes 2001-02-02 05:30:40 Re: [NOVICE] Re: Sizing of LARGE databases.
Previous Message Francisco Reyes 2001-02-02 05:23:12 Re: how to deteck empty tables in outer joins