RE: Importing Excel Spreadsheets into PostgreSQL - Mailing list pgsql-novice

From Francisco Reyes
Subject RE: Importing Excel Spreadsheets into PostgreSQL
Date
Msg-id Pine.BSF.4.32.0102020024360.1877-100000@zoraida.reyes.somos.net
Whole thread Raw
In response to RE: Importing Excel Spreadsheets into PostgreSQL  ("Ben Hooper" <Ben.Hooper@diskcopy.com.au>)
List 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.


pgsql-novice by date:

Previous
From: Salvatore Sferrazza
Date:
Subject: sequence/serial types
Next
From: Francisco Reyes
Date:
Subject: Re: explain plan