On 27/10/15 11:18, David Blomstrom wrote:
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
);
trying typing into psql, assuming this is a postgres user session:
\c geozoo2 david
(format is '\c DATABASE USERID').
If there is an error, please copy & paste the exact error message returned!
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
