create database from text file, to delete columns

Поиск
Список
Период
Сортировка
От e-letter
Тема create database from text file, to delete columns
Дата
Msg-id 298a6f60804020756j29a66010ie9b1f2b558194429@mail.gmail.com
обсуждение исходный текст
Ответы Re: create database from text file, to delete columns  ("Sean Davis" <sdavis2@mail.nih.gov>)
Список pgsql-novice
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"
Дата:
Сообщение: PGRcreateConn():Retry. h_errno is 1,reason is 'fe_sendauth: no password supplied
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: create database from text file, to delete columns