From: Philippe Salama <karebacnyc@yahoo.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: PostgreSQL Administration <pgsql-admin@postgresql.org>
Subject: Re: Advice on loading celko sql script
Date: Sat, 9 Dec 2006 12:08:38 -0800 (PST)
Message-ID: <968984.54994.qm@web90510.mail.mud.yahoo.com> (raw)
In-Reply-To: <542742.36836.qm@web31803.mail.mud.yahoo.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: karebacnyc@yahoo.com, rabroersma@yahoo.com
Subject: Re: Advice on loading celko sql script
In-Reply-To: <968984.54994.qm@web90510.mail.mud.yahoo.com>
References: <542742.36836.qm@web31803.mail.mud.yahoo.com> <968984.54994.qm@web90510.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox