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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com