Parse online RSS feeds and save to PostgreSQL

by

Posted on by

Want to parse online RSS feeds and save to PostgreSQL ? Want to schedule and automate this importing task?

Using FileToDB, a native GUI tool, you can import online RSS feeds to PostgreSQL easily and fast, and schedule and automate this importing task easily, no need to program, just a few mouse clicks!

Here you can download and install FileToDB.

Import online RSS feeds to PostgreSQL

Choose PostgreSQL and logon.

convert online FEED file to PostgreSQL table - Choose PostgreSQL and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert online FEED file to PostgreSQL table - task window

Select “Source Type” with “Url”.

convert online FEED file to PostgreSQL table - select type

then show the wizard.

1. Input the RSS feeds URL, and download to XML file.

import online RSS feeds to PostgreSQL - download from RSS feeds URL to XML file

2. Open the saved XML file.

import online RSS feeds to PostgreSQL - open saved XML file

3. Config target PostgreSQL table.

import online RSS feeds to PostgreSQL - config PostgreSQL table

You can create new PostgreSQL table by XML struct, just a few mouse clicks.

import online RSS feeds to PostgreSQL - create PostgreSQL table

Select table and config fields.

import online RSS feeds to PostgreSQL - config PostgreSQL fields

4. Summary.

import online RSS feeds to PostgreSQL - summary

5. Import.

import online RSS feeds to PostgreSQL - import to PostgreSQL

See importing results in PostgreSQL table

import online RSS feeds to PostgreSQL - view PostgreSQL table

You can schedule and automate this importing task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about FileToDB – the tool to import online RSS feeds to PostgreSQL

30-day free trial Download FileToDB