Paul,
once you get through the book perhaps you could submit a book review to
the techdocs website, along with a pg_dump of the sample database.
Robert Treat
On Mon, 2003-12-22 at 05:50, Richard Huxton wrote:
On Monday 22 December 2003 07:47, Paul Ganainm wrote: Not really a PostgreSQL question, but maybe somebody here knows the
answer!
I recently purchased Groff and Weinberg's The Complete Reference SQL,
and a fine meaty tome it is too!
However, I find to my absolute *_horror_* that there doesn't appear to
be an electronic version of the sample database - it's all down on paper
in Appendix A, but no way of downloading it electronically.
On the CD, there are files such as office.dat where the data is in the
format
22|Denver|Western|108|300000.00|186042.00
11|New York|Eastern|106|575000.00|692637.00
i.e. pipe delimited.
Read up on \copy and COPY - you can tell PG to use whatever delimiter you
want. Should make it straightforward then.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend