Hi,
I am trying to create local copy of DB from NCBI DB.
ftp://ftp.ncbi.nih.gov/snp/database/README.create_local_dbSNP.txt
The FTP site provides sql files and bcp -files.
I have started by trying to create tables as instructed:
psql -f dbSNP_main_table.sql dbSNP_main
Unfortunately there seems to be some syntax related issues:
psql:dbSNP_main_table.sql:579: ERROR: syntax error at or near "["
LINE 1: CREATE TABLE [Allele]
How can I get postresql to accept provided sql -files?
BR,
Sami