Parse online RSS feeds and save to PostgreSQL

by

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

Try Withdata FileToDB, a desktop RSS to PostgreSQL converter for Windows, MacOS, and Linux, Import online RSS feeds to PostgreSQL, Easy and Fast.

Download Withdata 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. Preview data will be in PostgreSQL table.

import online RSS feeds to PostgreSQL - summary

5. Import RSS feed to PostgreSQL.

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 (Windows) or .sh (Linux/macOS) file for “RSS feed to PostgreSQL” conversion.
  2. Set scheduled task for “RSS feed to PostgreSQL” conversion.

FAQ


More about Withdata FileToDBRSS feed to PostgreSQL converter