Re: Where do I enter commands?

[Rob Sargent <robjsargent@xxxxxxxxx>]

ok. now who has the url to the pithy heres-why-you-really-want-the-command-line.  

It distills to something about actually knowing what you’re doing.

On Oct 24, 2015, at 9:29 PM, David Blomstrom <david.blomstrom@xxxxxxxxx> wrote:

Good tip; I can now see the database I created. Thanks.

On Sat, Oct 24, 2015 at 8:20 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

On 10/24/2015 08:00 PM, David Blomstrom wrote:

"Is there a entry under Servers?"

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

That means you are not connected to the Server. Right click on the entry and select Connect. It will probably ask for a password, which should be the database password you created when you did the install.

On Sat, Oct 24, 2015 at 7:52 PM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxxx <mailto:pierce@xxxxxxxxxxxx>
        <mailto:pierce@xxxxxxxxxxxx <mailto:pierce@xxxxxxxxxxxx>>> 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@xxxxxxxxxxxxxx <mailto:pgsql-general@xxxxxxxxxxxxxx>
             <mailto:pgsql-general@xxxxxxxxxxxxxx
        <mailto:pgsql-general@xxxxxxxxxxxxxx>>)
             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> <http://www.geobop.org>



    --
    Adrian Klaver
    adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>




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

-- 
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

-- 

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