text: /*********************************************************************************
  # Copyright 2014 Observational Health Data Sciences and Informatics
  #
  #
  # Licensed under the Apache License, Version 2.0 (the "License");
  # you may not use this file except in compliance with the License.
  # You may obtain a copy of the License at
  #
  #     http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing, software
  # distributed under the License is distributed on an "AS IS" BASIS,
  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  # See the License for the specific language governing permissions and
  # limitations under the License.
  ********************************************************************************/
  
  /************************
  
   ####### #     # ####### ######      #####  ######  #     #           #######
   #     # ##   ## #     # #     #    #     # #     # ##   ##    #    # #
   #     # # # # # #     # #     #    #       #     # # # # #    #    # #
   #     # #  #  # #     # ######     #       #     # #  #  #    #    # ######
   #     # #     # #     # #          #       #     # #     #    #    #       #
   #     # #     # #     # #          #     # #     # #     #     #  #  #     #
   ####### #     # ####### #           #####  ######  #     #      ##    #####
  
  
  Script to load the common data model, version 5.0 vocabulary tables for PostgreSQL database on Windows (MS-DOS style file paths)
  The database account running this script must have the "superuser" permission in the database.
  
  Notes
  
  1) There is no data file load for the SOURCE_TO_CONCEPT_MAP table because that table is deprecated in CDM version 5.0
  2) This script assumes the CDM version 5 vocabulary zip file has been unzipped into the "C:\CDMV5VOCAB" directory.
  3) If you unzipped your CDM version 5 vocabulary files into a different directory then replace all file paths below, with your directory path.
  4) Truncate each table that will be lodaed below, before running this script.
  
  last revised: 5 Dec 2014
  
  author:  Lee Evans
  
  
  *************************/
  
  \COPY VOCABULARY FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/VOCABULARY.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY CONCEPT_CLASS FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/CONCEPT_CLASS.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY DOMAIN FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/DOMAIN.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY CONCEPT FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/CONCEPT.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY DRUG_STRENGTH FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/DRUG_STRENGTH.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY RELATIONSHIP FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/RELATIONSHIP.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY CONCEPT_RELATIONSHIP FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/CONCEPT_RELATIONSHIP.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY CONCEPT_ANCESTOR FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/CONCEPT_ANCESTOR.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  
  \COPY CONCEPT_SYNONYM FROM '/Users/mjg994/Documents/source/omop-abstractor/db/migrate/CommonDataModel-5.3.0/PostgreSQL/VocabImport/CONCEPT_SYNONYM.csv' WITH DELIMITER E'\t' CSV HEADER QUOTE E'\b' ;
  