Re: Where do I enter commands? - Mailing list pgsql-general

On 10/24/2015 09:19 PM, David Blomstrom wrote:
> I'm a writer. I studied programing and MySQL so I could create websites
> that I can publish my articles to. I don't have time to keep up with the
> endless technology - MySQL, PDO, stored procedures, PHP, JavaScript,
> JQuery, and on and on - especially when I have to work for a living.
> I've been using MySQL for years, so I'm familiar with it. It therefore
> makes sense for me to find a GUI as similar to MySQL as possible.
>
> With phpMyAdmin, I can easily create, modify, copy and migrate tables
> between databases. If that can be done as easily with a
> command-line-tool, even after surviving the learning curve, then I'm
> interested. But it's really hard to imagine how that could be.

pgAdmin will allow you to do those things. phpPgAdmin also, though I
have never used it, so I can not be of much help there. The predominate
command line tool folks are referring to is psql:

http://www.postgresql.org/docs/9.4/interactive/app-psql.html

For dumping databases or their contained objects there is pg_dump:

http://www.postgresql.org/docs/9.4/interactive/app-pgdump.html

for restoring non-plain text dumps there is pg_restore

http://www.postgresql.org/docs/9.4/interactive/app-pgdump.html

for plain text dumps just use psql.

These three programs will cover most of your use cases. The benefit to
using these tools is that you end of working with scripts that then can
be put under version control. Takes a little bit of time to set up but
the payoff is worth it for anything above the really simple level.

>
> Thanks for the tips.
>
> On Sat, Oct 24, 2015 at 9:07 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 10/24/2015 08:52 PM, Rob Sargent wrote:
>
>         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.
>
>
>     Everyone has to start somewhere. The point is get someone using
>     Postgres in manner they are comfortable with, then they can start
>     exploring the possibilities. I personally find the command line more
>     productive, but there is a learning curve.
>
>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
>
> --
> David Blomstrom
> Writer & Web Designer (Mac, M$ & Linux)
> www.geobop.org <http://www.geobop.org>


--
Adrian Klaver
adrian.klaver@aklaver.com