load PATSTAT to Postgresql

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

altayoz
Posts: 1
Joined: Thu Jul 02, 2015 10:18 am

load PATSTAT to Postgresql

Post by altayoz » Thu Jul 02, 2015 10:34 am

Dear all,
I share my bash scripts to load PATSTAT into Postgresql. You can obtain all scripts from github.

https://github.com/altay-oz/load_patstat

One of the scripts also helps to check if all tables are correctly loaded.

altay özaygen


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: load PATSTAT to Postgresql

Post by nico.rasters » Fri Jul 03, 2015 4:01 pm

Welcome to the board and thank you for sharing!
________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


Rachie
Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

Re: load PATSTAT to Postgresql

Post by Rachie » Wed Dec 02, 2015 3:15 am

Wonderful! Would anyone like to help me port it to MySQL?


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: load PATSTAT to Postgresql

Post by nico.rasters » Wed Dec 02, 2015 1:03 pm

________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


Rachie
Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

Re: load PATSTAT to Postgresql

Post by Rachie » Sun Dec 06, 2015 6:15 pm

I saw, but it's not quite the same as having some shell scripts to load and check everything. Ideally, the two would be combined. I'm wondering if anyone would like to work on this with me.


Post Reply