Re: Where do I enter commands? - Mailing list pgsql-general

From David Blomstrom
Subject Re: Where do I enter commands?
Date
Msg-id CAA54Z0jCi=Ek7Yr+itdjQfYCybsWt179yui6530PAwcVSqxSbQ@mail.gmail.com
Whole thread Raw
In response to Re: Where do I enter commands?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Where do I enter commands?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
"Is there a entry under Servers?"

PostgreSQL 9.5 (localhost) - but there's a red X over it.

On Sat, Oct 24, 2015 at 7:52 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/24/2015 07:44 PM, David Blomstrom wrote:
Hmmm...I have pgAdminIII. When I click on Server, there's no option to
create a database.

I would spend some time here:

http://www.pgadmin.org/docs/1.20/index.html

before going much further, just to get the gist of pgAdmin.

In the meantime, you have to connect to the Server before you can create anything on it. Is there a entry under Servers?


On Sat, Oct 24, 2015 at 7:37 PM, John R Pierce <pierce@hogranch.com
<mailto:pierce@hogranch.com>> wrote:

    On 10/24/2015 7:33 PM, David Blomstrom wrote:

        I'd greatly prefer a GUI. It seems like a command-line tool
        would be incredibly tedious when creating tables, modifying
        them, filling them with data, etc. Thanks.


    normally, your application programs do the data filling part, manual
    data entry direct via sql is fairly uncommon.

    anyways, the GUI is pgAdmin, and you can create a database by
    opening the server, and selecting 'new database...', give it an
    owner, etc.   then open that database, find hte Public schema
    therewithin, and create your table(s) in that schema...

    --
    john r pierce, recycling bits in santa cruz



    --
    Sent via pgsql-general mailing list (pgsql-general@postgresql.org
    <mailto:pgsql-general@postgresql.org>)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-general




--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org <http://www.geobop.org>


--
Adrian Klaver
adrian.klaver@aklaver.com



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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Where do I enter commands?
Next
From: Adrian Klaver
Date:
Subject: Re: Where do I enter commands?