P&D Help

P&D 02a.2021 (PostgreSQL dump) (probesdrugs_02a_2021_dump.zip)

P&D 01.2021 (PostgreSQL dump) (probesdrugs_01_2021_dump.zip)

P&D 03.2020 (PostgreSQL dump) (probesdrugs_03_2020_dump.tar.gz)

P&D 02.2020 (PostgreSQL dump) (probesdrugs_02_2020_dump.tar.gz)

P&D 01.2020 (PostgreSQL dump) (probesdrugs_01_2020_dump.tar.gz)

P&D 11.2019 (PostgreSQL dump) (probesdrugs_11_2019_dump.tar.gz)

P&D 10.2019 (PostgreSQL dump) (probesdrugs_10_2019_dump.tar.gz)

P&D 09.2019 (PostgreSQL dump) (probesdrugs_09_2019_dump.tar.gz)

# To restore the data, first, you need to extract (unzip) the dump and create an empty database:

CREATE DATABASE database_name WITH OWNER username;

# Then you can restore the dump using:

psql -d database_name -U username -f /path/to/dump

Please be aware that internal database IDs are not preserved and may change from version to version. The only IDs that are consistently preserved are compounds' PDIDs, which can be used to link to P&D.