Wordpress to PostgreSQL
This node.js script will translate the WXR file exported by WordPress into a script to create a PostgreSQL database with the following structure:
Table: wp_posts
wp_id BIGINT(20)
post_author BIGINT(20)
post_date DATETIME
post_date_gmt DATETIME
post_content LONGTEXT
post_title TEXT
post_excerpt TEXT
post_status VARCHAR(20)
This is similar to the table used in the WordPress MySQL database for posts, but without as much cruft.
Setting Up
If you don't have an existing database, create one:
createdb my_database
Create the 'posts' table in your database using the 'create_tables.sql' file from this project:
cat node_modules/wordpress_to_postgres/create_tables.sql | psql my_database
How To Use
wordpress_to_postgres yourusername.wordpress.2015-03-22.xml
That will generate a file with the prefix 'insert-posts' and a date-in-ms number appended to the end to make it unique. Use that file to add your blog posts to the database, like so:
cat insertPosts-1426965702734.sql | psql my_database
That's it!