Re: importing updated files into a database

On 08/19/2012 10:49 PM, fashouri wrote:
> I have files that are updated every 2 hours. I have to detect the files
> automatically and insert the information from them into a database. The
> files are simple text files and I know which part of them is useful for me.
> Our DBMS is Postgresql and programming language is python. what is your
> suggestion to do that? I want to make use of DAL (Database Abstraction
> Layer) or psycopg to make connection between the files and database and use
> postgresql LISTEN/NOTIFY techniques to detect the new files. if you agree
> with me please tell me how I can use LISTEN/NOTIFY functions to detect the
> files. Thank you

This is a re-post of a Stack Overflow question:

http://stackoverflow.com/questions/12026090/importing-updated-files-into-a-database

Fashouri, please try to link back to an SO question if you're re-posting
it somewhere else. That way you don't waste everybody's time repeating
what's already been said somewhere else and they can get onto new ideas.
Linking to the question also helps anybody who discovers your post in a
search later to find more information.

--
Craig Ringer