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
