From: | Mike <1100100(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | How to insert data from a text file |
Date: | 2009-06-18 17:51:39 |
Message-ID: | 8ca422820906181051j2f345529hafdf13c2c8302e37@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Background:
Thousands of folders and files filled with client data on the linux
samba server.
Searching for data is difficult due to ever-changing directory
structures and naming schemes.
Example (exaggerating to make a point):
/air/water/vegetable/animal/broccoli/potato/crabby_client.doc
/animal/broccoli/air/vegetable/poise_and_honor.pdf
It goes on for about 650,000 files
I used the following command to gather all file and directory names.
"/abc" is the main directory on the linux samba server where all
company data is located:
root(at)acme:/# ls -Ralh /abc > /home/mike/file_output.txt
file_output.txt is 33 megs. and lists approximately 650,000 file names
and their directory paths.
I want to pull all the file name info. and directory path info. from
"file_output.txt" and place each file name into a postgresql database
along with the related file location information.
The ultimate goal is to be able to make an alpha-numeric query and be
presented with matching file names and their location on the samba
server.
How do I pull the data from "file_output.txt" and place it into the
postgres database?
Any guidance and pointed RTFM declarations greatly appreciated.
Thanks,
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2009-06-18 18:04:31 | Re: How to insert data from a text file |
Previous Message | Lennin Caro | 2009-06-18 15:10:53 | Re: problem with sequence number using a trigger |