Re: Recursive Arrays 101

On Mon, Oct 26, 2015 at 5:02 PM, Adrian Klaver <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]:

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