Re: Recursive Arrays 101

[David Blomstrom <david.blomstrom@xxxxxxxxx>]

I pasted this into the shell...

CREATE ROLE david

LOGIN

CREATEDB;

CREATE DATABASE GeoZoo2

OWNER david;

and I did it again, replacing LOGIN with my password, but when I refresh pgAdmin III, there are no new databases.

And when I paste this in, it doesn't create a table...

CREATE TABLE public.gz_life_mammals2

(

  id            int PRIMARY KEY,

  taxon         text UNIQUE NOT NULL,

  parent        text NOT NULL,

  slug          text,

  name_common   text,

  plural        text,

  extinct       smallint NOT NULL,

  rank          smallint NOT NULL,

  key           smallint NOT NULL

);