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

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@aklaver.com <mailto: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>
>         <mailto: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>
>              <mailto: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> <http://www.geobop.org>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
>
> --
> David Blomstrom
> Writer & Web Designer (Mac, M$ & Linux)
> www.geobop.org <http://www.geobop.org>


--
Adrian Klaver
adrian.klaver@aklaver.com