On 10/26/2015 05:07 PM, David Blomstrom wrote:
On Mon, Oct 26, 2015 at 5:02 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto: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]:
So hitting Enter created the second prompt on each line?
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"
Well this went nowhere.
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).
-- 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
