Re: Where do I enter commands?

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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(at)hogranch(dot)com <mailto:pierce(at)hogranch(dot)com>
> <mailto:pierce(at)hogranch(dot)com <mailto:pierce(at)hogranch(dot)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(at)postgresql(dot)org <mailto:pgsql-general(at)postgresql(dot)org>
> <mailto:pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
>
> --
> David Blomstrom
> Writer & Web Designer (Mac, M$ & Linux)
> www.geobop.org <http://www.geobop.org>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com