ok. now who has the url to the pithy heres-why-you-really-want-the-command-line.
It distills to something about actually knowing what you’re doing. > On Oct 24, 2015, at 9:29 PM, David Blomstrom <david.blomst...@gmail.com> > wrote: > > 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 > <mailto: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> > <mailto: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 > <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>> > <mailto: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>> > <mailto: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 > <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 > <http://www.geobop.org/>> <http://www.geobop.org <http://www.geobop.org/>> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> > > > > > -- > David Blomstrom > Writer & Web Designer (Mac, M$ & Linux) > www.geobop.org <http://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/>