Re: Basic Tutorials for 9.0

On Nov 10, 11:07 pm, robjsarg(dot)(dot)(dot)(at)gmail(dot)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(dot)(dot)(dot)(at)postgresql(dot)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