Re: Where do I enter commands?

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

On Sat, Oct 24, 2015 at 8:20 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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(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
>

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