Re: Recursive Arrays 101 - Mailing list pgsql-general

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.