From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Philippe Salama <karebacnyc(at)yahoo(dot)com> |
Cc: | PostgreSQL Administration <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Advice on loading celko sql script |
Date: | 2006-12-09 20:04:00 |
Message-ID: | 542742.36836.qm@web31803.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
--- Philippe Salama <karebacnyc(at)yahoo(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Salama | 2006-12-09 20:08:38 | Re: Advice on loading celko sql script |
Previous Message | Daniel Cristian Cruz | 2006-12-09 19:45:25 | Re: Should duplicate indexes on same column and same table |