Re: Recursive Arrays 101

On 10/26/2015 05:07 PM, David Blomstrom wrote:
>
>
> On Mon, Oct 26, 2015 at 5:02 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto: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]:

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.klaver@aklaver.com