Re: Recursive Arrays 101

From: David Blomstrom <david(dot)blomstrom(at)gmail(dot)com>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recursive Arrays 101
Date: 2015-10-26 23:27:14
Message-ID: CAA54Z0jiP-CToxwSNAknaa0NckjSUw+0ueViujRh4t81m7NT+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

LOL - This is precisely why I prefer GUI's. ;)

I have two PostgreSQL icons on my taskbar - a blue elephant (pgAdmin III)
and a little monitor (PSQL). When I click on PSQL, it always opens at least
two windows or instances. When I type things in and hit enter, it spawns
more windows. I've counted at least as many as a dozen.

Sometimes a window will stop working: nothing happens when I type something
and hit enter. In that event, I have to force close PSQL and start from
scratch.

When I open pgAdmin III, a second icon appears on the taskbar. However, it
appears that they're one and the same; just a fluke, I guess.

On Mon, Oct 26, 2015 at 4:22 PM, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz
> wrote:

> On 27/10/15 12:15, David Blomstrom wrote:
>
>>
>> Server [localhost]: \c geozoo2 david
>>
>> Database [postgres]:
>>
>>
>> *Shell2*
>>
>> Username [postgres]: \c geozoo2 david
>>
>> psql: warning: extra command-line argument "david" ignored
>>
>> psql: warning: extra command-line argument "l" ignored
>>
>> psql: invalid port number: "dt"
>>
>>
>> Press <return> to continue...
>>
>>
> In my psql seesion I get...
>
> gavin=> \c mydb mydb_admin
> You are now connected to database "mydb" as user "mydb_admin".
> mydb=>
>
>
> If you have multiple psql sessions, suggest you delete all except 1 or 2.
>
> By type of shell, is meant are using a bash shell in your terminal, or
> csh, or something else? Bash stands for BOurne Again Shell, it process
> commands like 'psql' that you type into the shell.
>
> Please copy i the email addresses of the other helping you & the mailing
> list!
>

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Blomstrom 2015-10-26 23:28:49 Re: Recursive Arrays 101
Previous Message John R Pierce 2015-10-26 23:26:10 Re: Recursive Arrays 101