FAERS

This repository contains files setting up an FAERS Postgres database

Create postgres database faers

sudo -u postgres createdb faers postgres

Create schema

sudo -u postgres psql faers < create-tables.sql

Download FAERS files

# download FAERS file from FDA website
./download.sh

# extract contents
./extract.sh

Load data into tables

Load extracts into Postgres

./load_data.sh

Create indices

sudo -u postgres psql faers < create-indices.sql