* offset is a postgresql reserved word; cannot be used as a column name

[dbsnp.git] / schema / human_9606_schema / human_9606_table_postgresql.sql

diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql
index 7dc165a636cf8df45da5d8d08347e3a0d7ce00e2..a4407284317638edda4f7cca59921cabaf0d34c0 100644 (file)
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -612,7 +612,7 @@ snp_type char(2) NOT NULL ,
 snp_id int NULL ,
 gi int NULL ,
 accession_how_cd int NOT NULL ,
-'offset' int NULL ,
+offset_ int NULL ,
 asn_to int NULL ,
 lf_ngbr int NULL ,
 rf_ngbr int NULL ,
@@ -653,7 +653,7 @@ snp_type char(2) NOT NULL ,
 snp_id int NULL ,
 gi int NULL ,
 accession_how_cd int NULL ,
-'offset' int NULL ,
+offset_ int NULL ,
 asn_to int NULL ,
 lf_ngbr int NULL ,
 rf_ngbr int NULL ,