Re: Where do I enter commands?

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(dot)blomstrom(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com <mailto: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> <mailto: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 <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>>
> <mailto: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>>
> <mailto: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 <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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com> <mailto: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/> <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/>