From: | David Blomstrom <david(dot)blomstrom(at)gmail(dot)com> |
---|---|
To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Recursive Arrays 101 |
Date: | 2015-10-26 21:26:24 |
Message-ID: | CAA54Z0ite=2PF9c8nao__0yJjLBfTxVi96KjaPO1jZ8WY=qU=g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Here's what it looks like 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 "Primary Key" PRIMARY KEY (id),
CONSTRAINT "Unique Key" UNIQUE (taxon)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.gz_life_mammals
OWNER TO postgres;
* * * * *
I don't even have a clue what OIDS=FALSE means; I haven't read up on it
yet. It's just there by default. I haven't figured out how to change the
NULL value for any columns, other than toggle back and forth between NULL
and NOT NULL.
To assign a user, would I just ask it to associate a table with my
username? Can I do that with pgAdmin3?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | David Blomstrom | 2015-10-26 21:45:45 | Importing CSV File |
Previous Message | Rob Sargent | 2015-10-26 21:24:16 | Re: Recursive Arrays 101 |