README.md 648 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13


`psql "host=127.0.0.1 port=5432 dbname=omop password=postgres" -c "CREATE SCHEMA omop" -U postgres`

`psql "host=127.0.0.1 port=5432 dbname=omop password=postgres" -c "\i omop_ddl_postgres.sql" -U postgres`

`psql "host=127.0.0.1 port=5432 dbname=omop password=postgres" -c "\i omop_pk_postgres.sql" -U postgres`

`psql "host=127.0.0.1 port=5432 dbname=omop password=postgres" -c "\i omop_constraints_postgres.sql" -U postgres`

`psql "host=127.0.0.1 port=5432 dbname=omop password=postgres" -c "\i omop_indexes_postgres.sql" -U postgres`

`psql "host=127.0.0.1 port=5432 dbname=omop password=postgres" -c "DROP SCHEMA omop CASCADE" -U postgres`