It's hard to imagine creating a table with a command-line tool - in the step-by-step process I use with phpMyAdmin, that is. If you can learn the proper syntax for creating a table and put together a script for a generic table that you can easily modify, then maybe it would be a lot easier with a command-line tool.
In phpMyAdmin, I've become accustomed to simply copying existing tables, then adding, deleting and renaming columns as needed.
I can see PostgreSQL is going to have a learning curve - hopefully shorter than the years it took me to learn MySQL - but it looks interesting. The community seems painfully small compared to MySQL, and there are less online resources. But I'm guessing that will change in the coming years. I remember when CSS was a strange, foreign thing. ;)
On Sun, Oct 25, 2015 at 6:28 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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
