Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E732F9F9FDA for ; Sat, 9 Dec 2006 16:04:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 20658-07 for ; Sat, 9 Dec 2006 16:04:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id 70E779F9F46 for ; Sat, 9 Dec 2006 16:04:02 -0400 (AST) Received: (qmail 37585 invoked by uid 60001); 9 Dec 2006 20:04:00 -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=fP47Q2T5j7zQpB2yUH7z9vI5DJVL8LC7JwcPoRY3CrOwm/Gzl9lSB3U/w34bKD14WIP7xrYFDoSPNfncD2G4Ou1+4IdGHPfBgWAv3KsUQ90OsfFxciDSfuFsPO9rwuL5NGKc7J8zIp4MgIzhnjo8BFdHSqTfCqyfTSNFJDiB7OY=; X-YMail-OSG: JgaL92cVM1nKFPvO0lx83IImmrZnvDA3l.T8I9ZdQjp3ttMvZ1oVrQimXpHqb21DHCHcI0KKCMyD0unkGfhXurj3Ee78G9F7y03XmVQHIGORkmCfg_9lPvBSAHzfXjc6lKciYqLnSYReiqir3khnBry86ct7hJE5cRkioEukHboj6ozQwDDf3rwbKc.C Received: from [75.84.83.178] by web31803.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 12:04:00 PST Date: Sat, 9 Dec 2006 12:04:00 -0800 (PST) From: Richard Broersma Jr Subject: Re: Advice on loading celko sql script To: Philippe Salama Cc: PostgreSQL Administration In-Reply-To: <522653.62745.qm@web90515.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <542742.36836.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.069 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: ** X-Archive-Number: 200612/103 X-Sequence-Number: 23895 --- 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.