Postgres Pro
Downloads
Home   >   mailing lists

Re: Recursive Arrays 101 - Mailing list pgsql-general

From David Blomstrom
Subject Re: Recursive Arrays 101
Date
Msg-id CAA54Z0g4wyoM_8bqvM9wLqaAFPSdceE7cdgB06nKhaPX+tH7NA@mail.gmail.com
Whole thread Raw
In response to Re: Recursive Arrays 101  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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;

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Importing CSV File
Next
From: Aaron_Wright@selinc.com
Date:
Subject: PAM LDAP CREATE USER