Re: Recursive Arrays 101

Поиск
Список
Период
Сортировка
От David Blomstrom
Тема Re: Recursive Arrays 101
Дата
Msg-id CAA54Z0hT2kafAV3hjjA0qqntxisqOW7mZtjEtP2QES8yyqwKvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recursive Arrays 101  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Recursive Arrays 101
Re: Recursive Arrays 101
Список 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 по дате отправления:

Предыдущее
От: Michael Convey
Дата:
Сообщение: Red Hat Policies Regarding PostgreSQL
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Recursive Arrays 101