Script postgresql

[quintelosky]

Hello everyone,
Is it possible to create a script that sends data to PostgreSQL?
I want create a script that send a sql query to postgresql (I need read data from a csv and send to postgre

Thank you very much!

[manjey73]

Why not use the DbExport module in conjunction with the CSV reader driver?

[quintelosky]

Hi
Can you show me how to do it?
I use moddbexport, but it is associated to a command.
I want a script that detect a new xxx.csv, load the data, and write the data in postgresql.
Thanks

[manjey73]

I want a script that detect a new xxx.csv, load the data, and write the data in postgresql.

I’m not sure if the DrvCsvReader driver is capable of detecting new csv files. In addition, it requires a specific csv file structure.

If you do not know the name of the csv file, you will have to create a script in the system itself, for example, on bash on Linux and call it via crontab. Well, or through the Windows scheduler.
Rewrite or add information to a csv file that DrvCsvReader will understand and write the data to channels that will already be sent to the database using ModDbExport.
You need to understand the architecture of your csv files, how different they are in terms of the dataset, etc.

[Mikhail]

Hi,

Use Database Export Module to export data to the DB.
Use DrvCsvReader for reading CSV files.

• This reply was modified 7 months, 2 weeks ago by Mikhail.

[Mikhail]

This topic is about reading CSV.

[Author]

Posts