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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general