Re: Recursive Arrays 101 - Mailing list pgsql-general

From David Blomstrom
Subject Re: Recursive Arrays 101
Date
Msg-id CAA54Z0hT2kafAV3hjjA0qqntxisqOW7mZtjEtP2QES8yyqwKvQ@mail.gmail.com
Whole thread Raw
In response to Re: Recursive Arrays 101  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Recursive Arrays 101  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Recursive Arrays 101  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general


On Mon, Oct 26, 2015 at 5:02 PM, Adrian Klaver <adrian.klaver@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).

pgsql-general by date:

Previous
From: Michael Convey
Date:
Subject: Red Hat Policies Regarding PostgreSQL
Next
From: Adrian Klaver
Date:
Subject: Re: Recursive Arrays 101