| From: | David Blomstrom <david(dot)blomstrom(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Recursive Arrays 101 |
| Date: | 2015-10-26 21:58:13 |
| Message-ID: | CAA54Z0g4wyoM_8bqvM9wLqaAFPSdceE7cdgB06nKhaPX+tH7NA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
OK, I figured out how to drop the primary key and change the NULLS. So it
looks like this now:
CREATE TABLE public.gz_life_mammals
(
id integer NOT NULL,
taxon text NOT NULL,
parent text NOT NULL,
slug text,
namecommon text,
plural text,
extinct smallint NOT NULL,
rank smallint NOT NULL,
key smallint NOT NULL,
CONSTRAINT "Unique Key" UNIQUE (taxon)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.gz_life_mammals
OWNER TO postgres;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aaron_Wright | 2015-10-26 22:00:14 | PAM LDAP CREATE USER |
| Previous Message | Adrian Klaver | 2015-10-26 21:57:16 | Re: Importing CSV File |