create database from text file, to delete columns

Поиск
Список
Период
Сортировка
Искать
От
e-letter
Тема
create database from text file, to delete columns
Дата
Msg-id
298a6f60804020756j29a66010ie9b1f2b558194429@mail.gmail.com
Список
Дерево обсуждения
create database from text file, to delete columns e-letter <inpost@gmail.com>
Re: create database from text file, to delete columns "Sean Davis" <sdavis2@mail.nih.gov>
Re: create database from text file, to delete columns e-letter <inpost@gmail.com>
Re: create database from text file, to delete columns "Sean Davis" <sdavis2@mail.nih.gov>
Re: create database from text file, to delete columns e-letter <inpost@gmail.com>
Re: create database from text file, to delete columns "Sean Davis" <sdavis2@mail.nih.gov>
Readers,

I am using a program that saves data in csv format. I have realised
that I cannot view the file in my spreadsheet due to 256 column limit.

I think that I need to import the file into a database. Then I want to
review, then delete columns with null data.

I guess I can use the 'copy from' command? Also I do not know the
total number of columns so can I import into an empty database and the
columns are automatically created from the end of each line?

Yours,

postgresqlnovice@conference.jabber.org
В списке pgsql-novice по дате отправления
От: Eyenga, Patty
Дата:
От: Sean Davis
Дата:
FAQ