root/inputs/.NCBI/nodes/create.sql @ 5704
1 | 5491 | aaronmk | SELECT * |
---|---|---|---|
2 | FROM nodes |
||
3 | JOIN names USING (tax_id) |
||
4 | WHERE "name class" = 'scientific name' |
||
5 | ;
|
||
6 | |||
7 | ALTER TABLE :table ALTER COLUMN tax_id TYPE integer |
||
8 | USING tax_id::integer; |
||
9 | ALTER TABLE :table ALTER COLUMN "parent tax_id" TYPE integer |
||
10 | USING "parent tax_id"::integer; |
||
11 | |||
12 | ALTER TABLE :table ADD PRIMARY KEY (tax_id); |