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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@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
