From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
---|---|
To: | madler(at)sfec(dot)us, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Where is the command line? |
Date: | 2016-03-30 22:48:15 |
Message-ID: | 56FC57AF.6030505@archidevsys.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 31/03/16 11:05, madler(at)sfec(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-03-30 23:26:39 | Re: Where is the command line? |
Previous Message | madler | 2016-03-30 22:05:55 | Where is the command line? |