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
