Thread: Re: Advice on loading celko sql script

--- Philippe Salama <karebacnyc@yahoo.com> wrote:
> I am new to these things.  I have the command line prompt now, to postgresql on windows.  I also
> have a free admin program.   Do I simply RUN THE sql script to create the celko test tables.

The script that I made is from the postgresql pg_dump program.  It created a dump of a database
that I was using for my celko book.  If you run the script it will restore the database I created
into your postgresql cluster.

The following link gives some examples how you can restore this dumpfile into your database
cluster.
http://www.postgresql.org/docs/8.1/interactive/app-pgdump.html#PG-DUMP-EXAMPLES

If you are not sure how to use pg_dump you can read the rest of the document or you can run
"pg_dump.exe --help" from your command line.

Also, other people on the postgresql mailing list can benifit from our discussion.  In addition to
this, there are others on the list that might have better answers than the ones that I give.  So
it is important that you always send your emails to the mailing list.  The easiest way to do this
is to reply-all when you respond to emails from the list.

Regards,

Richard Broersma Jr.

I was a little confused about how to reply, but now I see the yahoo option REPLY TO EVERYONE, so I shall try it right now, and see if it works, and comes back from the majordomo listserve.

I have an older version of Postgresql 8.1 I think or 8.0.  So your script did not work perfectly.  I guess there are some new commands.

I tried to make your script work on MySQL,... but, at work I have the latest install of PostgreSQL done last week, so, I am sure your script will work there.  And once installed there, I can get the tables into Microsoft Access, and do my exercises there if I wish, and share the exercise tables at utteraccess.com

Richard Broersma Jr <rabroersma@yahoo.com> wrote:

--- Philippe Salama wrote:
> I am new to these things. I have the command line prompt now, to postgresql on windows. I also
> have a free admin program. Do I simply RUN THE sql script to create the celko test tables.

The script that I made is from the postgresql pg_dump program. It created a dump of a database
that I was using for my celko book. If you run the script it will restore the database I created
into your postgresql cluster.

The following link gives some examples how you can restore this dumpfile into your database
cluster.
http://www.postgresql.org/docs/8.1/interactive/app-pgdump.html#PG-DUMP-EXAMPLES

If you are not sure how to use pg_dump you can read the rest of the document or you can run
"pg_dump.exe --help" from your command line.

Also, other people on the postgresql mailing list can benifit from our discussion. In addition to
this, there are others on the list that might have better answers than the ones that I give. So
it is important that you always send your emails to the mailing list. The easiest way to do this
is to reply-all when you respond to emails from the list.

Regards,

Richard Broersma Jr.

---

Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.

> I was a little confused about how to reply, but now I see the yahoo option REPLY TO EVERYONE, so
> I shall try it right now, and see if it works, and comes back from the majordomo listserve.
>
> I have an older version of Postgresql 8.1 I think or 8.0.  So your script did not work
> perfectly.  I guess there are some new commands.
>
> I tried to make your script work on MySQL,... but, at work I have the latest install of
> PostgreSQL done last week, so, I am sure your script will work there.  And once installed there,
> I can get the tables into Microsoft Access, and do my exercises there if I wish, and share the
> exercise tables at utteraccess.com

I am using Postgresql 8.1.5.

you could upgrade your home server to 8.2.0 or 8.1.5 and it would work fine.

Regards,

Richard Broersma Jr.

OK. I just uninstalled my old postgresql 8.0 and the odbc, and now I am installing the 8.2.1 and will install the odbc driver, and then I shall run your script.

Installation seems easier now than it was 2 or 3 years ago.

Thanks

Richard Broersma Jr <rabroersma@yahoo.com> wrote:

> I was a little confused about how to reply, but now I see the yahoo option REPLY TO EVERYONE, so
> I shall try it right now, and see if it works, and comes back from the majordomo listserve.
>
> I have an older version of Postgresql 8.1 I think or 8.0. So your script did not work
> perfectly. I guess there are some new commands.
>
> I tried to make your script work on MySQL,... but, at work I have the latest install of
> PostgreSQL done last week, so, I am sure your script will work there. And once installed there,
> I can get the tables into Microsoft Access, and do my exercises there if I wish, and share the
> exercise tables at utteraccess.com

I am using Postgresql 8.1.5.

you could upgrade your home server to 8.2.0 or 8.1.5 and it would work fine.

Regards,

Richard Broersma Jr.

---

Everyone is raving about the all-new Yahoo! Mail beta.