
September 26th, 2012, 01:11 PM
|
|
Registered User
|
|
Join Date: Sep 2012
Posts: 1
Time spent in forums: 4 m 29 sec
Reputation Power: 0
|
|
|
Text file to postgres database
I need to built a database from a huge text file. The postgres version is 8.4.9. The file structure is as shown below. I have included 2 records from the file.
5350 65549 0 5551 5011 drwxr-x--- 8192 16384 3 2012-05-21 10:10:09 2012-03-27 06:26:24 2012-03-27 06:26:24 D2u -- /abcd/data/lmBC36F2F0-563E-4FB2-8CB9-3B0C8E624CC1/ac6d74f3fdcd4d9ab98bdfa37ffadefe__01cc484d11f2573e/data/users
5351 65549 0 5551 5011 -rw-r-x--- 53349 57344 1 2012-03-27 06:26:24 2012-03-27 06:26:24 2012-03-27 06:26:24 FAu -- /efgh/data/BC8BB4-FE6C-44A5-BB4B-7A293EE1847/all.utt.extr.txt.utf8
These records will be split up in to 13 columns in my table with the last column as the field 'path'. The OS is Linux.
I am a newbie, can any one guide me on how to start importing the data, what are the diff ways, please help
Thanks,
john
|