Where do I enter commands?

On 10/24/2015 06:21 PM, David Blomstrom wrote:

I just installed PostgreSQL and started reading the tutorial @
http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html and was
snowed at square one. To create a database, I'm supposed to type the
following command:

$ createdb mydb

But it doesn't say where I'm supposed to type it. When I click on the
PostgreSQL icon in my taskbar, a program called pgAdminIII opens up.
I've clicked File, Edit, Plugins, etc., but I don't see any clues about
where I'm supposed to type commands.

So lets backup up a bit:

1) What OS are you on?

2) How did you install Postgres?

3) What version of Postgres?
Hope it is not 8.0 implied by the doc link above.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL 9.5
after following the links to
http://www.enterprisedb.com/products-services-training/pgdownload#osx

I just learned about phpPGAdmin and installed it as well. But when I
navigate to localhost/phppgadmin, I get a "not found" error message.

On Sat, Oct 24, 2015 at 6:35 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 10/24/2015 06:21 PM, David Blomstrom wrote:

I just installed PostgreSQL and started reading the tutorial @
http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html and was
snowed at square one. To create a database, I'm supposed to type the
following command:

$ createdb mydb

But it doesn't say where I'm supposed to type it. When I click on the
PostgreSQL icon in my taskbar, a program called pgAdminIII opens up.
I've clicked File, Edit, Plugins, etc., but I don't see any clues about
where I'm supposed to type commands.

So lets backup up a bit:

1) What OS are you on?

2) How did you install Postgres?

3) What version of Postgres?
Hope it is not 8.0 implied by the doc link above.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

On 10/24/2015 07:20 PM, David Blomstrom wrote:

I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL
9.5 after following the links to
http://www.enterprisedb.com/products-services-training/pgdownload#osx

Well the tutorial is geared to using the command line to run programs.

Are you comfortable with the command line or would you prefer to use a
GUI like pgAdmin?

I just learned about phpPGAdmin and installed it as well. But when I
navigate to localhost/phppgadmin, I get a "not found" error message.

On Sat, Oct 24, 2015 at 6:35 PM, Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 10/24/2015 06:21 PM, David Blomstrom wrote:

I just installed PostgreSQL and started reading the tutorial @
http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html
and was
snowed at square one. To create a database, I'm supposed to type the
following command:

$ createdb mydb

But it doesn't say where I'm supposed to type it. When I click
on the
PostgreSQL icon in my taskbar, a program called pgAdminIII opens up.
I've clicked File, Edit, Plugins, etc., but I don't see any
clues about
where I'm supposed to type commands.

So lets backup up a bit:

1) What OS are you on?

2) How did you install Postgres?

3) What version of Postgres?
Hope it is not 8.0 implied by the doc link above.

--
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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

On Sat, Oct 24, 2015 at 7:28 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 10/24/2015 07:20 PM, David Blomstrom wrote:

I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL
9.5 after following the links to
http://www.enterprisedb.com/products-services-training/pgdownload#osx

Well the tutorial is geared to using the command line to run programs.

Are you comfortable with the command line or would you prefer to use a GUI
like pgAdmin?

I just learned about phpPGAdmin and installed it as well. But when I
navigate to localhost/phppgadmin, I get a "not found" error message.

On Sat, Oct 24, 2015 at 6:35 PM, Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 10/24/2015 06:21 PM, David Blomstrom wrote:

I just installed PostgreSQL and started reading the tutorial @
http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html
and was
snowed at square one. To create a database, I'm supposed to type
the
following command:

$ createdb mydb

But it doesn't say where I'm supposed to type it. When I click
on the
PostgreSQL icon in my taskbar, a program called pgAdminIII opens
up.
I've clicked File, Edit, Plugins, etc., but I don't see any
clues about
where I'm supposed to type commands.

So lets backup up a bit:

1) What OS are you on?

2) How did you install Postgres?

3) What version of Postgres?
Hope it is not 8.0 implied by the doc link above.

--
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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Hmmm...I have pgAdminIII. When I click on Server, there's no option to
create a database.

On Sat, Oct 24, 2015 at 7:37 PM, John R Pierce <pierce@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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

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

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@hogranch.com
<mailto:pierce@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>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org <http://www.geobop.org&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

"Is there a entry under Servers?"

PostgreSQL 9.5 (localhost) - but there's a red X over it.

On Sat, Oct 24, 2015 at 7:52 PM, Adrian Klaver <adrian.klaver@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

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@hogranch.com
<mailto:pierce@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>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org <http://www.geobop.org&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

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

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@hogranch.com <mailto:pierce@hogranch.com>
<mailto:pierce@hogranch.com <mailto:pierce@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>>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org <http://www.geobop.org&gt; <http://www.geobop.org&gt;

--
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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Good tip; I can now see the database I created. Thanks.

On Sat, Oct 24, 2015 at 8:20 PM, Adrian Klaver <adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@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

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@hogranch.com <mailto:pierce@hogranch.com>
<mailto:pierce@hogranch.com <mailto:pierce@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>>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org <http://www.geobop.org&gt; <http://www.geobop.org&gt;

--
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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

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 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

Thanks for the tips.

On Sat, Oct 24, 2015 at 9:07 PM, Adrian Klaver <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

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

On Sat, Oct 24, 2015 at 07:33:15PM -0700, David Blomstrom wrote:

It seems like a command-line tool would be
incredibly tedious when creating tables, modifying them, filling them with
data, etc.

For whatever it's worth, I find quite the opposite: once you have the
hang of the command line, it is so much more efficient for these
things (you can script everything up in your favourite editor) that I
find I never go back to the GUI unless I need diagrams and so on.

I think the others in the thread are giving you the right
instructions, so I've nothing to add on the GUI. But do consider
trying out the command line. You'll be surprised at the power you get
once the initial learning curve is over.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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.

Thanks for the tips.

I would ignore Rob, he obviously is suffering from a lack of coffee. Our
community always tries to help new users. It is great to see you here.

Sincerely,

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Since you are just starting, you should probably familarize yourself with
how PgAdmin works with PostgreSQL.
Therefore, it is best you refer to the documentation for PgAdmin.

PgAdmin III
http://www.pgadmin.org/docs/1.20/index.html

I also suggest you obtain a copy of one, or both, of the following two
books to help you with PostgreSQL.

Beginning Databases with PostgreSQL: From Novice to Professional
http://www.amazon.com/gp/product/1590594789?keywords=postgresql&amp;qid=1445778326&amp;ref_=sr_1_3&amp;s=books&amp;sr=1-3

PostgreSQL Administration Essentials
http://www.amazon.com/gp/product/1783988983?keywords=postgresql&amp;qid=1445778326&amp;ref_=sr_1_7&amp;s=books&amp;sr=1-7

You can also find a very extensive listing of other books about PostgreSQL
here:

http://www.postgresql.org/docs/books/

On Sun, Oct 25, 2015 at 5:21 AM, Joshua D. Drake <jd@commandprompt.com>
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.

Thanks for the tips.

I would ignore Rob, he obviously is suffering from a lack of coffee. Our
community always tries to help new users. It is great to see you here.

Sincerely,

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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@aklaver.com>
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@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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

On Sun, Oct 25, 2015 at 07:57:48AM -0700, David Blomstrom wrote:

In phpMyAdmin, I've become accustomed to simply copying existing tables,
then adding, deleting and renaming columns as needed.

Oh! Interesting. I suspect you're actually _undermining_ your
ability to use the database (because often when you copy a table it's
a sign that you're using the database like a spreadsheet, and you're
giving up a lot of functionality that way).

But, suppose you're wanting to do that, then here's the easy way to do
it:

--- if you want the same table structure without the data

CREATE TABLE newtable AS SELECT * FROM oldtable WHERE 1=0;

-- if you want the same table with some data

CREATE TABLE newtable AS SELECT columns, you, want, in, order
FROM oldtable
[WHERE conditions];

If you want only some columns or new order or something, the WHERE
clause in the latter statement should be 1=0. It makes a null set
always. Handy trick.

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.

It should be much easier. You have the basics from MySQL already.
Consistency and rigour are the changes ;-)

A

--
Andrew Sullivan
ajs@crankycanuck.ca

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general