Creating a DB

From: Sami Pietilä <sami(dot)pietila(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creating a DB
Date: 2012-09-16 09:02:36
Message-ID: CAN08J2iJHtGFNkZS7upL6H5Osds0Y3ckTF_a_5MfLrUPkm+1RA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2012-09-16 11:47:16 Re: Creating a DB
Previous Message Kevin Grittner 2012-09-14 18:03:01 Re: Question about join