Parse online RSS feeds and save to PostgreSQL without programming

by

Posted on by

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

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import online RSS feeds to PostgreSQL easily and fast.

Download FileToDB Download 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

Import RSS feed to PostgreSQL in command line

Save “RSS feed to PostgreSQL” session, then you can:

Set scheduled tasks for importing RSS feed to PostgreSQL

You can schedule and automate this importing task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ

More about FileToDB – RSS feed to PostgreSQL converter