Re: [GENERAL] Recursive Arrays 101

[David Blomstrom]

 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
);