Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3D9EF9FA1DA for ; Sat, 9 Dec 2006 16:08:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 18392-04 for ; Sat, 9 Dec 2006 16:08:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90510.mail.mud.yahoo.com (web90510.mail.mud.yahoo.com [216.252.100.177]) by postgresql.org (Postfix) with SMTP id B633F9F9F46 for ; Sat, 9 Dec 2006 16:08:40 -0400 (AST) Received: (qmail 55344 invoked by uid 60001); 9 Dec 2006 20:08:39 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=LwDfw2VXDTh/mKAAuLDryysFTrVkqj5Sy9KAcGMsrr6faVQvQGwmyLvR5YsVjnMdvVDVKZj+zXfoLV1MfUTLDXUuKEm8+IPkMfxVEeZrmFCRJn9FXaHIfggS62uZraNQBSTA6sXU1Bly/+cKGNRIhuNoif5Df4hsxpBrXAye5fs=; X-YMail-OSG: 8VMwH_oVM1mPFR6Un9I_TV8_zn_pLK7sfnSaHqj4pjI8kcBNclZh94n7WC41iBNwTSxtHa2f2fMKcQKyrbjRb4qI4SroO9lTjQONsOtAFhIklCXmq1zLjU8PNt_jTs.bMZINw8vxTNOjaBzVAekLA_nMrLG26ifBK.U- Received: from [70.19.76.226] by web90510.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 12:08:38 PST Date: Sat, 9 Dec 2006 12:08:38 -0800 (PST) From: Philippe Salama Subject: Re: Advice on loading celko sql script To: Richard Broersma Jr Cc: PostgreSQL Administration In-Reply-To: <542742.36836.qm@web31803.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1386518112-1165694918=:54994" Content-Transfer-Encoding: 8bit Message-ID: <968984.54994.qm@web90510.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.108 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: ** X-Archive-Number: 200612/104 X-Sequence-Number: 23896 --0-1386518112-1165694918=:54994 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 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. --0-1386518112-1165694918=:54994 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-1386518112-1165694918=:54994--