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