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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
