importing updated files into a database - Mailing list pgsql-general

From fashouri
Subject importing updated files into a database
Date
Msg-id 1345387783137-5720349.post@n5.nabble.com
Whole thread Raw
Responses Re: importing updated files into a database  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
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




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/importing-updated-files-into-a-database-tp5720349.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: How hard would a "path" operator be to implement in PostgreSQL
Next
From: Gavin Flower
Date:
Subject: Re: Schemas vs partitioning vs multiple databases for archiving