On Mon, Oct 26, 2015 at 5:02 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 10/26/2015 04:42 PM, David Blomstrom wrote: > >> Last login: Mon Oct 26 16:35:25 on ttys002 >> >> /Library/PostgreSQL/9.5/scripts/runpsql.sh; exit >> >> Davids-MacBook-Pro-2:~ davidblomstrom$ >> /Library/PostgreSQL/9.5/scripts/runpsql.sh; exit >> >> Server [localhost]: \l >> >> Database [postgres]: \dt >> >> Port [5432]: >> >> Username [postgres]: Cmd-Spacebar >> > > You are mixing instructions. Do: > > Server [localhost]: > > Database [postgres]: > > Port [5432]: > > Username [postgres]: > > where you just hit Enter after each prompt above. The [parameter]s are > default values and I would just accept them for now. Once you get through > the prompts it will open a terminal with psql loaded. > > Last login: Mon Oct 26 16:48:35 on ttys002 /Library/PostgreSQL/9.5/scripts/runpsql.sh; exit Davids-MacBook-Pro-2:~ davidblomstrom$ /Library/PostgreSQL/9.5/scripts/runpsql.sh; exit Server [localhost]: Server [localhost]: Database [postgres]: Database [postgres]: Port [5432]: Port [5432]: Username [postgres]: Username [postgres]: psql: warning: extra command-line argument "[5432]:" ignored psql: warning: extra command-line argument "[postgres]:" ignored psql: warning: extra command-line argument "Database" ignored psql: warning: extra command-line argument "[postgres]:" ignored psql: invalid port number: "Port" Press <return> to continue...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 );logout Saving session... ...copying shared history... ...saving history...truncating history files... ...completed. [Process completed] * * * * * @ Rob Sargent - I already have two databases, postrgres and geozoo. Geozoo has two tables in it. I was just trying to create another table with the shell (PSQL).
