On 10/26/2015 03:18 PM, David Blomstrom wrote:
I pasted this into the shell...

What shell, psql?


CREATE ROLE david
LOGIN
CREATEDB;

CREATE DATABASE GeoZoo2
OWNER david;

Did you see any errors?


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

No LOGIN is an attribute of ROLE it is not the password

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


--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to