Re: Basic Tutorials for 9.0 - Mailing list pgsql-general

From ray
Subject Re: Basic Tutorials for 9.0
Date
Msg-id 7a1f2b1e-2cbc-49e2-a43b-00767ac48257@o2g2000vbh.googlegroups.com
Whole thread Raw
In response to Basic Tutorials for 9.0  (ray <ray@aarden.us>)
Responses Re: Basic Tutorials for 9.0  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
On Nov 10, 11:07 pm, robjsarg...@gmail.com (Rob Sargent) wrote:
> ray wrote:
> > I just downloaded 9.0 onto my laptop and desktop Windows XP machines.
> > Nether one could run the stack builder.  Windows would fault any time
> > I tried to run it.  I tried inputing the proxy server but that did not
> > help.
>
> > I have found many tutorials but none look like the 9.0.  Many seem to
> > be for EnterpriseDB version 8.3.
>
> > I need a lot of help.  I have seen tutorials that say to use pgAdmin
> > III but they only address high level functions; I haven't found
> > anything that gives a step by step.  When I first bring up pgAdmin,
> > the server entry has a red 'X' through it.  I played around and got it
> > to open and show tables and schema and things but I just stumbled on
> > it.  Now I don't rmember how I got there.  But then I don't know what
> > to do when I am.
>
> > I also tried the shell.  create mydb.  I used all the defaults but the
> > console came back and rejected all the defaults and closed the
> > console.
>
> > I would like to export an Excel file as CVS and ;'copy' into pg.  So I
> > would like to learn how to create a new database and what ever goes
> > along with that to acheive this goal.
>
> > I would appreciate all help.
>
> > Thanks,
> > ray
>
> if the defaults are in play the owning account should be able to do
>
> createdb somedbname;
>
> You left of the "db" in createdb in your posting.
>
> The red X by a server means you haven't logged in to that server.
>
> Since you've got all the way in to there that might be best spot from
> which to explore  There is a create database on the right-click menu.
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general- Hide quoted text -
>
> - Show quoted text -

I really didn't understand.  I was trying to create a new db inside of
the pg shell.  I found that I needed to do it at the OS command
prompt.  This was totally unclear in the manual.  Now I have found
that the copy cammand is to be done in the shell.  Now if I could just
find out if it is working.  I can't seem to look into the db.

Slow, but progressing.

I would like any help/suggestions.

Thanks,
ray

pgsql-general by date:

Previous
From: ray
Date:
Subject: Re: Help with Stack Builder
Next
From: smallfish
Date:
Subject: Re: Basic Tutorials for 9.0