Postgres Pro
Downloads
Home   >   mailing lists

create database from text file, to delete columns - Mailing list pgsql-novice

From e-letter
Subject create database from text file, to delete columns
Date
Msg-id 298a6f60804020756j29a66010ie9b1f2b558194429@mail.gmail.com
Whole thread Raw
Responses Re: create database from text file, to delete columns  ("Sean Davis" <sdavis2@mail.nih.gov>)
List pgsql-novice
Tree view 
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 by date:

Previous
From: "Eyenga, Patty"
Date:
Subject: PGRcreateConn():Retry. h_errno is 1,reason is 'fe_sendauth: no password supplied
Next
From: "Sean Davis"
Date:
Subject: Re: create database from text file, to delete columns