OHDSI Home | Forums | Wiki | Github

PostgreSQL script for CDMv4

CDM Builders
#1

Hi ALL,

Where can I find the PostgreSQL script to create the data base schema in CDMv4?

Thanks,

#2

Hi!

Just last week I took the Oracle-based CDMv4 and Oracle-based Vocabulary DDL files and ran them through this sed script to generate PostgreSQL-compatible CDMv4 and PostgreSQL-compatible Vocabulary DDL files.

I didn’t end up loading in any data to either the CDMv4 or Vocabulary schemas, so I can’t guarantee how accurate this conversion is. I’d verify their accuracy before putting them in production, but they might help get you up and running quickly.

#3

you may find some help here https://github.com/OHDSI/CommonDataModel

#4

Thanks. I will try this.

Yonghui

t