RE: Importing Excel Spreadsheets into PostgreSQL

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема RE: Importing Excel Spreadsheets into PostgreSQL
Дата
Msg-id Pine.BSF.4.32.0102020024360.1877-100000@zoraida.reyes.somos.net
обсуждение исходный текст
Ответ на RE: Importing Excel Spreadsheets into PostgreSQL  ("Ben Hooper" <Ben.Hooper@diskcopy.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Salvatore Sferrazza
Дата:
Сообщение: sequence/serial types
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: explain plan