Skip site navigation (1) Skip section navigation (2)

How to insert data from a text file

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 (view raw or flat)
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

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2009-06-18 18:04:31
Subject: Re: How to insert data from a text file
Previous:From: Lennin CaroDate: 2009-06-18 15:10:53
Subject: Re: problem with sequence number using a trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group