Good tip; I can now see the database I created. Thanks. On Sat, Oct 24, 2015 at 8:20 PM, Adrian Klaver <adrian.kla...@aklaver.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.kla...@aklaver.com <mailto:adrian.kla...@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 >> <pie...@hogranch.com <mailto:pie...@hogranch.com> >> <mailto:pie...@hogranch.com <mailto:pie...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> >> >> -- >> David Blomstrom >> Writer & Web Designer (Mac, M$ & Linux) >> www.geobop.org <http://www.geobop.org> >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- David Blomstrom Writer & Web Designer (Mac, M$ & Linux) www.geobop.org