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 CAA54Z0iEYyNywi_6i+etVnUP4ieYo_X0oav9v9JKsNhA98ORtQ@mail.gmail.com
Whole thread Raw
In response to Re: Recursive Arrays 101  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Recursive Arrays 101  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Recursive Arrays 101  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Recursive Arrays 101  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Recursive Arrays 101  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view
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
);

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Importing CSV File
Next
From: Adrian Klaver
Date:
Subject: Re: Recursive Arrays 101