Re: Where is the command line?

On 31/03/16 11:05, madler@sfec.us wrote:
> I'm trying to learn postgreSQL.  I installed 9.3.1. on a PC running
> Windows 8.  I needed that version to work with some DHI software.  It
> installed successfully.  I now have a number of postgreSQL associated
> items in my list of apps.  They are:
> Application Stack Builder
> installation notes
> pgadmin documentation
> pgadmin III
> postgreSQL documentation
> postgreSQL release notes
> Reload Configuration
> SQL Shell (psql)
>
> That's The problem is that it doesn’t tell me where to iuse that
> command.  I have no program called “postgreSQL on my computer despite
> successfully installing the software. The only program that has a
> command prompt is the SQL shell one, and that doesn’t seem to be
> right, because none of the things the tutorials say comes next
> actually happens.
>
> I used the pgadmin III to create a new database and new user in order
> to log into the DHI software.  That's as far as I know what to do with
> the DHI software.  I'm trying to learn what else to do with the
> postgreSQL, so I've looked up a bunch of tutorials.  They all start out
>
> To create a new database, in this example named mydb, use the
> following command:
> $ createdb mydb
>
> That's The problem is that it doesn’t tell me where to use that
> command.  I have no program called “postgreSQL” on my computer despite
> successfully installing the software. The only program that has a
> command prompt is the SQL shell one, and that doesn’t seem to be
> right, because none of the things the tutorials say comes next
> actually happens.
>
> I looked all over pgadmin and could not find a command line, though it
> does have menu items for creating a new database.  This leads me to
> suspect that perhaps I have a different sort of interface.  However, I
> can’t progress in the tutorials because I can’t find a command line
> anywhere, and I can’t find any tutorials that tell me how to use
> interface I have, if that’s what the situation is.  Any advice?
>
> Michael
Hi Michael,

I must admit that I tend to avoid using Microsoft O/S's like the plague,
as they are difficult to use and insecure - so I use a Linux
distribution (Fedora in my case, but there are hundreds to chose from).

You will need to find how to get up a terminal, may be called a DOS
prompt, or something else.  Essentially something that allows you to use
the command line.  We don't have any Microsoft boxen in the house, so I
can't go look.

Once you have PostgreSQL setup to run, I tend to use psql from the
command line coupled with a text editor to create SQL scripts. However,
you can use pgadmin3 - though I personally find psql much easier to use.

Note that the latest version of PostgreSQL is actually 9.5.1, with 9.5.2
due to be released next week!


Cheers,
Gavin